What data look like?

import pandas as pd
import os
from directory_tree import display_tree
from sklearn.metrics import roc_auc_score
from pathlib import Path
import duckdb

DATA_FOLDER="home-credit-credit-risk-model-stability"
assert Path(DATA_FOLDER).exists()
display_tree(DATA_FOLDER)

home-credit-credit-risk-model-stability/
├── csv_files/
│   ├── test/
│   │   ├── test_applprev_1_0.csv
│   │   ├── test_applprev_1_1.csv
│   │   ├── test_applprev_1_2.csv
│   │   ├── test_applprev_2.csv
│   │   ├── test_base.csv
│   │   ├── test_credit_bureau_a_1_0.csv
│   │   ├── test_credit_bureau_a_1_1.csv
│   │   ├── test_credit_bureau_a_1_2.csv
│   │   ├── test_credit_bureau_a_1_3.csv
│   │   ├── test_credit_bureau_a_1_4.csv
│   │   ├── test_credit_bureau_a_2_0.csv
│   │   ├── test_credit_bureau_a_2_1.csv
│   │   ├── test_credit_bureau_a_2_10.csv
│   │   ├── test_credit_bureau_a_2_11.csv
│   │   ├── test_credit_bureau_a_2_2.csv
│   │   ├── test_credit_bureau_a_2_3.csv
│   │   ├── test_credit_bureau_a_2_4.csv
│   │   ├── test_credit_bureau_a_2_5.csv
│   │   ├── test_credit_bureau_a_2_6.csv
│   │   ├── test_credit_bureau_a_2_7.csv
│   │   ├── test_credit_bureau_a_2_8.csv
│   │   ├── test_credit_bureau_a_2_9.csv
│   │   ├── test_credit_bureau_b_1.csv
│   │   ├── test_credit_bureau_b_2.csv
│   │   ├── test_debitcard_1.csv
│   │   ├── test_deposit_1.csv
│   │   ├── test_other_1.csv
│   │   ├── test_person_1.csv
│   │   ├── test_person_2.csv
│   │   ├── test_static_0_0.csv
│   │   ├── test_static_0_1.csv
│   │   ├── test_static_0_2.csv
│   │   ├── test_static_cb_0.csv
│   │   ├── test_tax_registry_a_1.csv
│   │   ├── test_tax_registry_b_1.csv
│   │   └── test_tax_registry_c_1.csv
│   └── train/
│       ├── train_applprev_1_0.csv
│       ├── train_applprev_1_1.csv
│       ├── train_applprev_2.csv
│       ├── train_base.csv
│       ├── train_credit_bureau_a_1_0.csv
│       ├── train_credit_bureau_a_1_1.csv
│       ├── train_credit_bureau_a_1_2.csv
│       ├── train_credit_bureau_a_1_3.csv
│       ├── train_credit_bureau_a_2_0.csv
│       ├── train_credit_bureau_a_2_1.csv
│       ├── train_credit_bureau_a_2_10.csv
│       ├── train_credit_bureau_a_2_2.csv
│       ├── train_credit_bureau_a_2_3.csv
│       ├── train_credit_bureau_a_2_4.csv
│       ├── train_credit_bureau_a_2_5.csv
│       ├── train_credit_bureau_a_2_6.csv
│       ├── train_credit_bureau_a_2_7.csv
│       ├── train_credit_bureau_a_2_8.csv
│       ├── train_credit_bureau_a_2_9.csv
│       ├── train_credit_bureau_b_1.csv
│       ├── train_credit_bureau_b_2.csv
│       ├── train_debitcard_1.csv
│       ├── train_deposit_1.csv
│       ├── train_other_1.csv
│       ├── train_person_1.csv
│       ├── train_person_2.csv
│       ├── train_static_0_0.csv
│       ├── train_static_0_1.csv
│       ├── train_static_cb_0.csv
│       ├── train_tax_registry_a_1.csv
│       ├── train_tax_registry_b_1.csv
│       └── train_tax_registry_c_1.csv
├── feature_definitions.csv
├── parquet_files/
│   ├── test/
│   │   ├── test_applprev_1_0.parquet
│   │   ├── test_applprev_1_1.parquet
│   │   ├── test_applprev_1_2.parquet
│   │   ├── test_applprev_2.parquet
│   │   ├── test_base.parquet
│   │   ├── test_credit_bureau_a_1_0.parquet
│   │   ├── test_credit_bureau_a_1_1.parquet
│   │   ├── test_credit_bureau_a_1_2.parquet
│   │   ├── test_credit_bureau_a_1_3.parquet
│   │   ├── test_credit_bureau_a_1_4.parquet
│   │   ├── test_credit_bureau_a_2_0.parquet
│   │   ├── test_credit_bureau_a_2_1.parquet
│   │   ├── test_credit_bureau_a_2_10.parquet
│   │   ├── test_credit_bureau_a_2_11.parquet
│   │   ├── test_credit_bureau_a_2_2.parquet
│   │   ├── test_credit_bureau_a_2_3.parquet
│   │   ├── test_credit_bureau_a_2_4.parquet
│   │   ├── test_credit_bureau_a_2_5.parquet
│   │   ├── test_credit_bureau_a_2_6.parquet
│   │   ├── test_credit_bureau_a_2_7.parquet
│   │   ├── test_credit_bureau_a_2_8.parquet
│   │   ├── test_credit_bureau_a_2_9.parquet
│   │   ├── test_credit_bureau_b_1.parquet
│   │   ├── test_credit_bureau_b_2.parquet
│   │   ├── test_debitcard_1.parquet
│   │   ├── test_deposit_1.parquet
│   │   ├── test_other_1.parquet
│   │   ├── test_person_1.parquet
│   │   ├── test_person_2.parquet
│   │   ├── test_static_0_0.parquet
│   │   ├── test_static_0_1.parquet
│   │   ├── test_static_0_2.parquet
│   │   ├── test_static_cb_0.parquet
│   │   ├── test_tax_registry_a_1.parquet
│   │   ├── test_tax_registry_b_1.parquet
│   │   └── test_tax_registry_c_1.parquet
│   └── train/
│       ├── train_applprev_1_0.parquet
│       ├── train_applprev_1_1.parquet
│       ├── train_applprev_2.parquet
│       ├── train_base.parquet
│       ├── train_credit_bureau_a_1_0.parquet
│       ├── train_credit_bureau_a_1_1.parquet
│       ├── train_credit_bureau_a_1_2.parquet
│       ├── train_credit_bureau_a_1_3.parquet
│       ├── train_credit_bureau_a_2_0.parquet
│       ├── train_credit_bureau_a_2_1.parquet
│       ├── train_credit_bureau_a_2_10.parquet
│       ├── train_credit_bureau_a_2_2.parquet
│       ├── train_credit_bureau_a_2_3.parquet
│       ├── train_credit_bureau_a_2_4.parquet
│       ├── train_credit_bureau_a_2_5.parquet
│       ├── train_credit_bureau_a_2_6.parquet
│       ├── train_credit_bureau_a_2_7.parquet
│       ├── train_credit_bureau_a_2_8.parquet
│       ├── train_credit_bureau_a_2_9.parquet
│       ├── train_credit_bureau_b_1.parquet
│       ├── train_credit_bureau_b_2.parquet
│       ├── train_debitcard_1.parquet
│       ├── train_deposit_1.parquet
│       ├── train_other_1.parquet
│       ├── train_person_1.parquet
│       ├── train_person_2.parquet
│       ├── train_static_0_0.parquet
│       ├── train_static_0_1.parquet
│       ├── train_static_cb_0.parquet
│       ├── train_tax_registry_a_1.parquet
│       ├── train_tax_registry_b_1.parquet
│       └── train_tax_registry_c_1.parquet
└── sample_submission.csv

DATA_DIR='home-credit-credit-risk-model-stability/parquet_files/train'
p = Path(DATA_DIR)

import ibis
import ibis
import ibis.selectors as s

# Set up ibis
ibis.options.interactive = True

assert (p / 'train_base.parquet').exists
print('Your is training target is column `target`')
ibis.read_parquet((p / 'train_base.parquet')).head(3)

Your is training target is column `target`

┏━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━┓
┃ case_id ┃ date_decision ┃ MONTH  ┃ WEEK_NUM ┃ target ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━┩
│ int64   │ string        │ int64  │ int64    │ int64  │
├─────────┼───────────────┼────────┼──────────┼────────┤
│       0 │ 2019-01-03    │ 201901 │        0 │      0 │
│       1 │ 2019-01-03    │ 201901 │        0 │      0 │
│       2 │ 2019-01-04    │ 201901 │        0 │      0 │
└─────────┴───────────────┴────────┴──────────┴────────┘

From reading this notebook ‘https://www.kaggle.com/code/jetakow/home-credit-2024-starter-notebook’

• Last letter of column name is ‘P’ or ‘A’ is float64
• Strings are categorical variables

Observer data below:

• there are cardinality amont the tables.

# load data into directory
data_files=list(p.glob('*_1.parquet'))#load_all data
ds = {f.name:ibis.read_parquet(f) for f in data_files}
# preview of data
for i, j in ds.items():
    print(i)
    print(display(j.head(3)))

train_other_1.parquet
None
train_credit_bureau_a_1_1.parquet
None
train_static_0_1.parquet
None
train_tax_registry_c_1.parquet
None
train_person_1.parquet
None
train_credit_bureau_b_1.parquet
None
train_tax_registry_b_1.parquet
None
train_debitcard_1.parquet
None
train_applprev_1_1.parquet
None
train_tax_registry_a_1.parquet
None
train_deposit_1.parquet
None
train_credit_bureau_a_2_1.parquet
None

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ case_id ┃ amtdebitincoming_4809443A ┃ amtdebitoutgoing_4809440A ┃ amtdepositbalance_4809441A ┃ amtdepositincoming_4809444A ┃ amtdepositoutgoing_4809442A ┃ num_group1 ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ int64   │ float64                   │ float64                   │ float64                    │ float64                     │ float64                     │ int64      │
├─────────┼───────────────────────────┼───────────────────────────┼────────────────────────────┼─────────────────────────────┼─────────────────────────────┼────────────┤
│   43801 │                12466.6010 │                12291.2000 │                      914.2 │                         0.0 │                   304.80002 │          0 │
│   43991 │                 3333.4001 │                 3273.4001 │                        0.0 │                         0.0 │                     0.00000 │          0 │
│   44001 │                10000.0000 │                10000.0000 │                        0.0 │                         0.0 │                     0.00000 │          0 │
└─────────┴───────────────────────────┴───────────────────────────┴────────────────────────────┴─────────────────────────────┴─────────────────────────────┴────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ annualeffectiverate_199L ┃ annualeffectiverate_63L ┃ classificationofcontr_13M ┃ classificationofcontr_400M ┃ contractst_545M ┃ contractst_964M ┃ contractsum_5085717L ┃ credlmt_230A ┃ credlmt_935A ┃ dateofcredend_289D ┃ dateofcredend_353D ┃ dateofcredstart_181D ┃ dateofcredstart_739D ┃ dateofrealrepmt_138D ┃ debtoutstand_525A ┃ debtoverdue_47A ┃ description_351M ┃ dpdmax_139P ┃ dpdmax_757P ┃ dpdmaxdatemonth_442T ┃ dpdmaxdatemonth_89T ┃ dpdmaxdateyear_596T ┃ dpdmaxdateyear_896T ┃ financialinstitution_382M ┃ financialinstitution_591M ┃ instlamount_768A ┃ instlamount_852A ┃ interestrate_508L ┃ lastupdate_1112D ┃ lastupdate_388D ┃ monthlyinstlamount_332A ┃ monthlyinstlamount_674A ┃ nominalrate_281L ┃ nominalrate_498L ┃ num_group1 ┃ numberofcontrsvalue_258L ┃ numberofcontrsvalue_358L ┃ numberofinstls_229L ┃ numberofinstls_320L ┃ numberofoutstandinstls_520L ┃ numberofoutstandinstls_59L ┃ numberofoverdueinstlmax_1039L ┃ numberofoverdueinstlmax_1151L ┃ numberofoverdueinstlmaxdat_148D ┃ numberofoverdueinstlmaxdat_641D ┃ numberofoverdueinstls_725L ┃ numberofoverdueinstls_834L ┃ outstandingamount_354A ┃ outstandingamount_362A ┃ overdueamount_31A ┃ overdueamount_659A ┃ overdueamountmax2_14A ┃ overdueamountmax2_398A ┃ overdueamountmax2date_1002D ┃ overdueamountmax2date_1142D ┃ overdueamountmax_155A ┃ overdueamountmax_35A ┃ overdueamountmaxdatemonth_284T ┃ overdueamountmaxdatemonth_365T ┃ overdueamountmaxdateyear_2T ┃ overdueamountmaxdateyear_994T ┃ periodicityofpmts_1102L ┃ periodicityofpmts_837L ┃ prolongationcount_1120L ┃ prolongationcount_599L ┃ purposeofcred_426M ┃ purposeofcred_874M ┃ refreshdate_3813885D ┃ residualamount_488A ┃ residualamount_856A ┃ subjectrole_182M ┃ subjectrole_93M ┃ totalamount_6A ┃ totalamount_996A ┃ totaldebtoverduevalue_178A ┃ totaldebtoverduevalue_718A ┃ totaloutstanddebtvalue_39A ┃ totaloutstanddebtvalue_668A ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ int64   │ float64                  │ float64                 │ string                    │ string                     │ string          │ string          │ float64              │ float64      │ float64      │ string             │ string             │ string               │ string               │ string               │ float64           │ float64         │ string           │ float64     │ float64     │ float64              │ float64             │ float64             │ float64             │ string                    │ string                    │ float64          │ float64          │ float64           │ string           │ string          │ float64                 │ float64                 │ float64          │ float64          │ int64      │ float64                  │ float64                  │ float64             │ float64             │ float64                     │ float64                    │ float64                       │ float64                       │ string                          │ string                          │ float64                    │ float64                    │ float64                │ float64                │ float64           │ float64            │ float64               │ float64                │ string                      │ string                      │ float64               │ float64              │ float64                        │ float64                        │ float64                     │ float64                       │ float64                 │ float64                │ float64                 │ float64                │ string             │ string             │ string               │ float64             │ float64             │ string           │ string          │ float64        │ float64          │ float64                    │ float64                    │ float64                    │ float64                     │
├─────────┼──────────────────────────┼─────────────────────────┼───────────────────────────┼────────────────────────────┼─────────────────┼─────────────────┼──────────────────────┼──────────────┼──────────────┼────────────────────┼────────────────────┼──────────────────────┼──────────────────────┼──────────────────────┼───────────────────┼─────────────────┼──────────────────┼─────────────┼─────────────┼──────────────────────┼─────────────────────┼─────────────────────┼─────────────────────┼───────────────────────────┼───────────────────────────┼──────────────────┼──────────────────┼───────────────────┼──────────────────┼─────────────────┼─────────────────────────┼─────────────────────────┼──────────────────┼──────────────────┼────────────┼──────────────────────────┼──────────────────────────┼─────────────────────┼─────────────────────┼─────────────────────────────┼────────────────────────────┼───────────────────────────────┼───────────────────────────────┼─────────────────────────────────┼─────────────────────────────────┼────────────────────────────┼────────────────────────────┼────────────────────────┼────────────────────────┼───────────────────┼────────────────────┼───────────────────────┼────────────────────────┼─────────────────────────────┼─────────────────────────────┼───────────────────────┼──────────────────────┼────────────────────────────────┼────────────────────────────────┼─────────────────────────────┼───────────────────────────────┼─────────────────────────┼────────────────────────┼─────────────────────────┼────────────────────────┼────────────────────┼────────────────────┼──────────────────────┼─────────────────────┼─────────────────────┼──────────────────┼─────────────────┼────────────────┼──────────────────┼────────────────────────────┼────────────────────────────┼────────────────────────────┼─────────────────────────────┤
│   19694 │                     NULL │                    NULL │ ea6782cc                  │ a55475b1                   │ 7241344e        │ a55475b1        │                 NULL │         NULL │          0.0 │ 2020-09-29         │ NULL               │ NULL                 │ 2014-09-29           │ NULL                 │          43315.26 │             0.0 │ a55475b1         │        20.0 │        NULL │                 NULL │                12.0 │              2017.0 │                NULL │ a55475b1                  │ P204_66_73                │              0.0 │             NULL │              NULL │ 2019-06-27       │ NULL            │                  0.0000 │                    NULL │             NULL │             NULL │          0 │                      2.0 │                      8.0 │                NULL │                NULL │                        NULL │                       NULL │                          22.0 │                          NULL │ NULL                            │ 2017-11-21                      │                        0.0 │                       NULL │                   NULL │                   NULL │              NULL │                0.0 │              2967.666 │                   NULL │ NULL                        │ 2018-03-31                  │              2967.666 │                 NULL │                           NULL │                            4.0 │                      2018.0 │                          NULL │                    NULL │                   NULL │                    NULL │                   NULL │ 60c73645           │ a55475b1           │ NULL                 │                NULL │                 0.0 │ ab3c25cf         │ ab3c25cf        │           NULL │             NULL │                        0.0 │                        0.0 │                   43315.26 │                         0.0 │
│   19694 │                     NULL │                    NULL │ ea6782cc                  │ a55475b1                   │ 7241344e        │ a55475b1        │                 NULL │         NULL │         NULL │ 2020-04-14         │ NULL               │ NULL                 │ 2016-04-14           │ NULL                 │              NULL │            NULL │ a55475b1         │        19.0 │        NULL │                 NULL │                 3.0 │              2018.0 │                NULL │ a55475b1                  │ P150_136_157              │             NULL │             NULL │              NULL │ 2019-07-03       │ NULL            │               5155.5425 │                    NULL │             NULL │             NULL │          1 │                     NULL │                     NULL │                NULL │                47.0 │                        NULL │                        9.0 │                          21.0 │                          NULL │ NULL                            │ 2018-03-08                      │                        0.0 │                       NULL │                   NULL │               43315.26 │              NULL │                0.0 │              5155.344 │                   NULL │ NULL                        │ 2017-01-19                  │              5061.540 │                 NULL │                           NULL │                           10.0 │                      2017.0 │                          NULL │                    NULL │                   30.0 │                    NULL │                   NULL │ 96a8fdfe           │ a55475b1           │ NULL                 │                NULL │                NULL │ a55475b1         │ a55475b1        │           NULL │         170000.0 │                       NULL │                       NULL │                       NULL │                        NULL │
│   19694 │                     NULL │                    NULL │ a55475b1                  │ a55475b1                   │ a55475b1        │ a55475b1        │                 NULL │         NULL │         NULL │ NULL               │ NULL               │ NULL                 │ NULL                 │ NULL                 │              NULL │            NULL │ a55475b1         │        NULL │        NULL │                 NULL │                NULL │                NULL │                NULL │ a55475b1                  │ a55475b1                  │             NULL │             NULL │              NULL │ NULL             │ NULL            │                    NULL │                    NULL │             NULL │             NULL │          2 │                     NULL │                     NULL │                NULL │                NULL │                        NULL │                       NULL │                          NULL │                          NULL │ NULL                            │ NULL                            │                       NULL │                       NULL │                   NULL │                   NULL │              NULL │               NULL │                  NULL │                   NULL │ NULL                        │ NULL                        │                  NULL │                 NULL │                           NULL │                           NULL │                        NULL │                          NULL │                    NULL │                   NULL │                    NULL │                   NULL │ a55475b1           │ a55475b1           │ 2019-07-10           │                NULL │                NULL │ a55475b1         │ a55475b1        │           NULL │             NULL │                       NULL │                       NULL │                       NULL │                        NULL │
└─────────┴──────────────────────────┴─────────────────────────┴───────────────────────────┴────────────────────────────┴─────────────────┴─────────────────┴──────────────────────┴──────────────┴──────────────┴────────────────────┴────────────────────┴──────────────────────┴──────────────────────┴──────────────────────┴───────────────────┴─────────────────┴──────────────────┴─────────────┴─────────────┴──────────────────────┴─────────────────────┴─────────────────────┴─────────────────────┴───────────────────────────┴───────────────────────────┴──────────────────┴──────────────────┴───────────────────┴──────────────────┴─────────────────┴─────────────────────────┴─────────────────────────┴──────────────────┴──────────────────┴────────────┴──────────────────────────┴──────────────────────────┴─────────────────────┴─────────────────────┴─────────────────────────────┴────────────────────────────┴───────────────────────────────┴───────────────────────────────┴─────────────────────────────────┴─────────────────────────────────┴────────────────────────────┴────────────────────────────┴────────────────────────┴────────────────────────┴───────────────────┴────────────────────┴───────────────────────┴────────────────────────┴─────────────────────────────┴─────────────────────────────┴───────────────────────┴──────────────────────┴────────────────────────────────┴────────────────────────────────┴─────────────────────────────┴───────────────────────────────┴─────────────────────────┴────────────────────────┴─────────────────────────┴────────────────────────┴────────────────────┴────────────────────┴──────────────────────┴─────────────────────┴─────────────────────┴──────────────────┴─────────────────┴────────────────┴──────────────────┴────────────────────────────┴────────────────────────────┴────────────────────────────┴─────────────────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ actualdpdtolerance_344P ┃ amtinstpaidbefduel24m_4187115A ┃ annuity_780A ┃ annuitynextmonth_57A ┃ applicationcnt_361L ┃ applications30d_658L ┃ applicationscnt_1086L ┃ applicationscnt_464L ┃ applicationscnt_629L ┃ applicationscnt_867L ┃ avgdbddpdlast24m_3658932P ┃ avgdbddpdlast3m_4187120P ┃ avgdbdtollast24m_4525197P ┃ avgdpdtolclosure24_3658938P ┃ avginstallast24m_3658937A ┃ avglnamtstart24m_4525187A ┃ avgmaxdpdlast9m_3716943P ┃ avgoutstandbalancel6m_4187114A ┃ avgpmtlast12m_4525200A ┃ bankacctype_710L ┃ cardtype_51L ┃ clientscnt12m_3712952L ┃ clientscnt3m_3712950L ┃ clientscnt6m_3712949L ┃ clientscnt_100L ┃ clientscnt_1022L ┃ clientscnt_1071L ┃ clientscnt_1130L ┃ clientscnt_136L ┃ clientscnt_157L ┃ clientscnt_257L ┃ clientscnt_304L ┃ clientscnt_360L ┃ clientscnt_493L ┃ clientscnt_533L ┃ clientscnt_887L ┃ clientscnt_946L ┃ cntincpaycont9m_3716944L ┃ cntpmts24_3658933L ┃ commnoinclast6m_3546845L ┃ credamount_770A ┃ credtype_322L ┃ currdebt_22A ┃ currdebtcredtyperange_828A ┃ datefirstoffer_1144D ┃ datelastinstal40dpd_247D ┃ datelastunpaid_3546854D ┃ daysoverduetolerancedd_3976961L ┃ deferredmnthsnum_166L ┃ disbursedcredamount_1113A ┃ disbursementtype_67L ┃ downpmt_116A ┃ dtlastpmtallstes_4499206D ┃ eir_270L ┃ equalitydataagreement_891L ┃ equalityempfrom_62L ┃ firstclxcampaign_1125D ┃ firstdatedue_489D ┃ homephncnt_628L ┃ inittransactionamount_650A ┃ inittransactioncode_186L ┃ interestrate_311L ┃ interestrategrace_34L ┃ isbidproduct_1095L ┃ isbidproductrequest_292L ┃ isdebitcard_729L ┃ lastactivateddate_801D ┃ lastapplicationdate_877D ┃ lastapprcommoditycat_1041M ┃ lastapprcommoditytypec_5251766M ┃ lastapprcredamount_781A ┃ lastapprdate_640D ┃ lastcancelreason_561M ┃ lastdelinqdate_224D ┃ lastdependentsnum_448L ┃ lastotherinc_902A ┃ lastotherlnsexpense_631A ┃ lastrejectcommoditycat_161M ┃ lastrejectcommodtypec_5251769M ┃ lastrejectcredamount_222A ┃ lastrejectdate_50D ┃ lastrejectreason_759M ┃ lastrejectreasonclient_4145040M ┃ lastrepayingdate_696D ┃ lastst_736L ┃ maininc_215A ┃ mastercontrelectronic_519L ┃ mastercontrexist_109L ┃ maxannuity_159A ┃ maxannuity_4075009A ┃ maxdbddpdlast1m_3658939P ┃ maxdbddpdtollast12m_3658940P ┃ maxdbddpdtollast6m_4187119P ┃ maxdebt4_972A ┃ maxdpdfrom6mto36m_3546853P ┃ maxdpdinstldate_3546855D ┃ maxdpdinstlnum_3546846P ┃ maxdpdlast12m_727P ┃ maxdpdlast24m_143P ┃ maxdpdlast3m_392P ┃ maxdpdlast6m_474P ┃ maxdpdlast9m_1059P ┃ maxdpdtolerance_374P ┃ maxinstallast24m_3658928A ┃ maxlnamtstart6m_4525199A ┃ maxoutstandbalancel12m_4187113A ┃ maxpmtlast3m_4525190A ┃ mindbddpdlast24m_3658935P ┃ mindbdtollast24m_4525191P ┃ mobilephncnt_593L ┃ monthsannuity_845L ┃ numactivecreds_622L ┃ numactivecredschannel_414L ┃ numactiverelcontr_750L ┃ numcontrs3months_479L ┃ numincomingpmts_3546848L ┃ numinstlallpaidearly3d_817L ┃ numinstls_657L ┃ numinstlsallpaid_934L ┃ numinstlswithdpd10_728L ┃ numinstlswithdpd5_4187116L ┃ numinstlswithoutdpd_562L ┃ numinstmatpaidtearly2d_4499204L ┃ numinstpaid_4499208L ┃ numinstpaidearly3d_3546850L ┃ numinstpaidearly3dest_4493216L ┃ numinstpaidearly5d_1087L ┃ numinstpaidearly5dest_4493211L ┃ numinstpaidearly5dobd_4499205L ┃ numinstpaidearly_338L ┃ numinstpaidearlyest_4493214L ┃ numinstpaidlastcontr_4325080L ┃ numinstpaidlate1d_3546852L ┃ numinstregularpaid_973L ┃ numinstregularpaidest_4493210L ┃ numinsttopaygr_769L ┃ numinsttopaygrest_4493213L ┃ numinstunpaidmax_3546851L ┃ numinstunpaidmaxest_4493212L ┃ numnotactivated_1143L ┃ numpmtchanneldd_318L ┃ numrejects9m_859L ┃ opencred_647L ┃ paytype1st_925L ┃ paytype_783L ┃ payvacationpostpone_4187118D ┃ pctinstlsallpaidearl3d_427L ┃ pctinstlsallpaidlat10d_839L ┃ pctinstlsallpaidlate1d_3546856L ┃ pctinstlsallpaidlate4d_3546849L ┃ pctinstlsallpaidlate6d_3546844L ┃ pmtnum_254L ┃ posfpd10lastmonth_333P ┃ posfpd30lastmonth_3976960P ┃ posfstqpd30lastmonth_3976962P ┃ previouscontdistrict_112M ┃ price_1097A ┃ sellerplacecnt_915L ┃ sellerplacescnt_216L ┃ sumoutstandtotal_3546847A ┃ sumoutstandtotalest_4493215A ┃ totaldebt_9A ┃ totalsettled_863A ┃ totinstallast1m_4525188A ┃ twobodfilling_608L ┃ typesuite_864L ┃ validfrom_1069D ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━┩
│ int64   │ float64                 │ float64                        │ float64      │ float64              │ float64             │ float64              │ float64               │ float64              │ float64              │ float64              │ float64                   │ float64                  │ float64                   │ float64                     │ float64                   │ float64                   │ float64                  │ float64                        │ float64                │ string           │ string       │ float64                │ float64               │ float64               │ float64         │ float64          │ float64          │ float64          │ float64         │ float64         │ float64         │ float64         │ float64         │ float64         │ float64         │ float64         │ float64         │ float64                  │ float64            │ float64                  │ float64         │ string        │ float64      │ float64                    │ string               │ string                   │ string                  │ float64                         │ float64               │ float64                   │ string               │ float64      │ string                    │ float64  │ boolean                    │ boolean             │ string                 │ string            │ float64         │ float64                    │ string                   │ float64           │ float64               │ boolean            │ boolean                  │ boolean          │ string                 │ string                   │ string                     │ string                          │ float64                 │ string            │ string                │ string              │ float64                │ float64           │ float64                  │ string                      │ string                         │ float64                   │ string             │ string                │ string                          │ string                │ string      │ float64      │ float64                    │ float64               │ float64         │ float64             │ float64                  │ float64                      │ float64                     │ float64       │ float64                    │ string                   │ float64                 │ float64            │ float64            │ float64           │ float64           │ float64            │ float64              │ float64                   │ float64                  │ float64                         │ float64               │ float64                   │ float64                   │ float64           │ float64            │ float64             │ float64                    │ float64                │ float64               │ float64                  │ float64                     │ float64        │ float64               │ float64                 │ float64                    │ float64                  │ float64                         │ float64              │ float64                     │ float64                        │ float64                  │ float64                        │ float64                        │ float64               │ float64                      │ float64                       │ float64                    │ float64                 │ float64                        │ float64             │ float64                    │ float64                   │ float64                      │ float64               │ float64              │ float64           │ boolean       │ string          │ string       │ string                       │ float64                     │ float64                     │ float64                         │ float64                         │ float64                         │ float64     │ float64                │ float64                    │ float64                       │ string                    │ float64     │ float64             │ float64              │ float64                   │ float64                      │ float64      │ float64           │ float64                  │ string             │ string         │ string          │
├─────────┼─────────────────────────┼────────────────────────────────┼──────────────┼──────────────────────┼─────────────────────┼──────────────────────┼───────────────────────┼──────────────────────┼──────────────────────┼──────────────────────┼───────────────────────────┼──────────────────────────┼───────────────────────────┼─────────────────────────────┼───────────────────────────┼───────────────────────────┼──────────────────────────┼────────────────────────────────┼────────────────────────┼──────────────────┼──────────────┼────────────────────────┼───────────────────────┼───────────────────────┼─────────────────┼──────────────────┼──────────────────┼──────────────────┼─────────────────┼─────────────────┼─────────────────┼─────────────────┼─────────────────┼─────────────────┼─────────────────┼─────────────────┼─────────────────┼──────────────────────────┼────────────────────┼──────────────────────────┼─────────────────┼───────────────┼──────────────┼────────────────────────────┼──────────────────────┼──────────────────────────┼─────────────────────────┼─────────────────────────────────┼───────────────────────┼───────────────────────────┼──────────────────────┼──────────────┼───────────────────────────┼──────────┼────────────────────────────┼─────────────────────┼────────────────────────┼───────────────────┼─────────────────┼────────────────────────────┼──────────────────────────┼───────────────────┼───────────────────────┼────────────────────┼──────────────────────────┼──────────────────┼────────────────────────┼──────────────────────────┼────────────────────────────┼─────────────────────────────────┼─────────────────────────┼───────────────────┼───────────────────────┼─────────────────────┼────────────────────────┼───────────────────┼──────────────────────────┼─────────────────────────────┼────────────────────────────────┼───────────────────────────┼────────────────────┼───────────────────────┼─────────────────────────────────┼───────────────────────┼─────────────┼──────────────┼────────────────────────────┼───────────────────────┼─────────────────┼─────────────────────┼──────────────────────────┼──────────────────────────────┼─────────────────────────────┼───────────────┼────────────────────────────┼──────────────────────────┼─────────────────────────┼────────────────────┼────────────────────┼───────────────────┼───────────────────┼────────────────────┼──────────────────────┼───────────────────────────┼──────────────────────────┼─────────────────────────────────┼───────────────────────┼───────────────────────────┼───────────────────────────┼───────────────────┼────────────────────┼─────────────────────┼────────────────────────────┼────────────────────────┼───────────────────────┼──────────────────────────┼─────────────────────────────┼────────────────┼───────────────────────┼─────────────────────────┼────────────────────────────┼──────────────────────────┼─────────────────────────────────┼──────────────────────┼─────────────────────────────┼────────────────────────────────┼──────────────────────────┼────────────────────────────────┼────────────────────────────────┼───────────────────────┼──────────────────────────────┼───────────────────────────────┼────────────────────────────┼─────────────────────────┼────────────────────────────────┼─────────────────────┼────────────────────────────┼───────────────────────────┼──────────────────────────────┼───────────────────────┼──────────────────────┼───────────────────┼───────────────┼─────────────────┼──────────────┼──────────────────────────────┼─────────────────────────────┼─────────────────────────────┼─────────────────────────────────┼─────────────────────────────────┼─────────────────────────────────┼─────────────┼────────────────────────┼────────────────────────────┼───────────────────────────────┼───────────────────────────┼─────────────┼─────────────────────┼──────────────────────┼───────────────────────────┼──────────────────────────────┼──────────────┼───────────────────┼──────────────────────────┼────────────────────┼────────────────┼─────────────────┤
│   40626 │                    NULL │                           NULL │    1976.2001 │                  0.0 │                 0.0 │                  0.0 │                   0.0 │                  1.0 │                  0.0 │                  0.0 │                      NULL │                     NULL │                      NULL │                        NULL │                      NULL │                      NULL │                     NULL │                           NULL │                   NULL │ NULL             │ NULL         │                    0.0 │                   0.0 │                   0.0 │             0.0 │              0.0 │              0.0 │              0.0 │            NULL │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │                     NULL │               NULL │                      0.0 │         36000.0 │ CAL           │          0.0 │                        0.0 │ NULL                 │ NULL                     │ NULL                    │                            NULL │                   0.0 │                   36000.0 │ GBA                  │          0.0 │ NULL                      │     0.28 │ NULL                       │ NULL                │ NULL                   │ NULL              │             0.0 │                       NULL │ CASH                     │              0.28 │                  NULL │ False              │ NULL                     │ NULL             │ NULL                   │ NULL                     │ a55475b1                   │ a55475b1                        │                    NULL │ NULL              │ a55475b1              │ NULL                │                   NULL │              NULL │                     NULL │ a55475b1                    │ a55475b1                       │                      NULL │ NULL               │ a55475b1              │ a55475b1                        │ NULL                  │ NULL        │         NULL │                        0.0 │                   0.0 │             0.0 │                NULL │                     NULL │                         NULL │                        NULL │           0.0 │                        0.0 │ NULL                     │                    NULL │                0.0 │                0.0 │               0.0 │               0.0 │                0.0 │                  0.0 │                      NULL │                     NULL │                            NULL │                  NULL │                      NULL │                      NULL │               1.0 │               NULL │                 0.0 │                        0.0 │                    0.0 │                   0.0 │                     NULL │                        NULL │            0.0 │                  NULL │                    NULL │                       NULL │                     NULL │                            NULL │                 NULL │                        NULL │                           NULL │                     NULL │                           NULL │                           NULL │                  NULL │                         NULL │                          NULL │                       NULL │                    NULL │                           NULL │                NULL │                       NULL │                      NULL │                         NULL │                   0.0 │                  0.0 │               0.0 │ NULL          │ OTHER           │ OTHER        │ NULL                         │                        NULL │                        NULL │                            NULL │                            NULL │                            NULL │        24.0 │                    0.0 │                        0.0 │                          NULL │ a55475b1                  │        NULL │                 0.0 │                  0.0 │                      NULL │                         NULL │          0.0 │               0.0 │                     NULL │ FO                 │ AL             │ NULL            │
│   40704 │                    NULL │                           NULL │    3731.2000 │                  0.0 │                 0.0 │                  0.0 │                   0.0 │                  0.0 │                  0.0 │                  0.0 │                      NULL │                     NULL │                      NULL │                        NULL │                      NULL │                      NULL │                     NULL │                           NULL │                   NULL │ NULL             │ NULL         │                    0.0 │                   0.0 │                   0.0 │             0.0 │              0.0 │              0.0 │              0.0 │            NULL │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │                     NULL │               NULL │                      0.0 │         30000.0 │ CAL           │          0.0 │                        0.0 │ NULL                 │ NULL                     │ NULL                    │                            NULL │                   0.0 │                   30000.0 │ GBA                  │          0.0 │ NULL                      │     0.45 │ NULL                       │ NULL                │ NULL                   │ NULL              │             1.0 │                       NULL │ CASH                     │              0.45 │                  NULL │ False              │ NULL                     │ NULL             │ NULL                   │ 2018-11-20               │ a55475b1                   │ a55475b1                        │                    NULL │ NULL              │ P94_109_143           │ NULL                │                   NULL │              NULL │                     NULL │ a55475b1                    │ a55475b1                       │                   54000.0 │ 2018-11-20         │ P198_131_9            │ P94_109_143                     │ NULL                  │ D           │         NULL │                        0.0 │                   0.0 │             0.0 │                NULL │                     NULL │                         NULL │                        NULL │           0.0 │                        0.0 │ NULL                     │                    NULL │                0.0 │                0.0 │               0.0 │               0.0 │                0.0 │                  0.0 │                      NULL │                     NULL │                            NULL │                  NULL │                      NULL │                      NULL │               2.0 │               NULL │                 0.0 │                        0.0 │                    0.0 │                   0.0 │                     NULL │                        NULL │            0.0 │                  NULL │                    NULL │                       NULL │                     NULL │                            NULL │                 NULL │                        NULL │                           NULL │                     NULL │                           NULL │                           NULL │                  NULL │                         NULL │                          NULL │                       NULL │                    NULL │                           NULL │                NULL │                       NULL │                      NULL │                         NULL │                   0.0 │                  0.0 │               0.0 │ False         │ OTHER           │ OTHER        │ NULL                         │                        NULL │                        NULL │                            NULL │                            NULL │                            NULL │        12.0 │                   NULL │                       NULL │                          NULL │ a55475b1                  │        NULL │                 0.0 │                  0.0 │                      NULL │                         NULL │          0.0 │               0.0 │                     NULL │ FO                 │ AL             │ NULL            │
│   40734 │                    NULL │                           NULL │    3731.2000 │                  0.0 │                 0.0 │                  1.0 │                   0.0 │                  0.0 │                  0.0 │                  1.0 │                      NULL │                     NULL │                      NULL │                        NULL │                      NULL │                      NULL │                     NULL │                           NULL │                   NULL │ NULL             │ NULL         │                    0.0 │                   0.0 │                   0.0 │             0.0 │              0.0 │              0.0 │              0.0 │            NULL │             0.0 │             0.0 │             0.0 │             0.0 │             0.0 │             1.0 │             0.0 │             0.0 │                     NULL │               NULL │                      0.0 │         30000.0 │ CAL           │          0.0 │                        0.0 │ NULL                 │ NULL                     │ NULL                    │                            NULL │                   0.0 │                   30000.0 │ GBA                  │          0.0 │ NULL                      │     0.45 │ NULL                       │ NULL                │ NULL                   │ NULL              │             0.0 │                       NULL │ CASH                     │              0.45 │                  NULL │ False              │ NULL                     │ NULL             │ NULL                   │ 2019-12-26               │ a55475b1                   │ a55475b1                        │                    NULL │ NULL              │ P94_109_143           │ NULL                │                   NULL │              NULL │                     NULL │ a55475b1                    │ a55475b1                       │                   50000.0 │ 2019-12-26         │ P45_84_106            │ P94_109_143                     │ NULL                  │ D           │         NULL │                        0.0 │                   0.0 │             0.0 │                NULL │                     NULL │                         NULL │                        NULL │           0.0 │                        0.0 │ NULL                     │                    NULL │                0.0 │                0.0 │               0.0 │               0.0 │                0.0 │                  0.0 │                      NULL │                     NULL │                            NULL │                  NULL │                      NULL │                      NULL │               1.0 │               NULL │                 0.0 │                        0.0 │                    0.0 │                   1.0 │                     NULL │                        NULL │            0.0 │                  NULL │                    NULL │                       NULL │                     NULL │                            NULL │                 NULL │                        NULL │                           NULL │                     NULL │                           NULL │                           NULL │                  NULL │                         NULL │                          NULL │                       NULL │                    NULL │                           NULL │                NULL │                       NULL │                      NULL │                         NULL │                   0.0 │                  0.0 │               1.0 │ False         │ OTHER           │ OTHER        │ NULL                         │                        NULL │                        NULL │                            NULL │                            NULL │                            NULL │        12.0 │                    0.0 │                        0.0 │                          NULL │ a55475b1                  │        NULL │                 1.0 │                  1.0 │                      NULL │                         NULL │          0.0 │               0.0 │                     NULL │ FO                 │ AL             │ NULL            │
└─────────┴─────────────────────────┴────────────────────────────────┴──────────────┴──────────────────────┴─────────────────────┴──────────────────────┴───────────────────────┴──────────────────────┴──────────────────────┴──────────────────────┴───────────────────────────┴──────────────────────────┴───────────────────────────┴─────────────────────────────┴───────────────────────────┴───────────────────────────┴──────────────────────────┴────────────────────────────────┴────────────────────────┴──────────────────┴──────────────┴────────────────────────┴───────────────────────┴───────────────────────┴─────────────────┴──────────────────┴──────────────────┴──────────────────┴─────────────────┴─────────────────┴─────────────────┴─────────────────┴─────────────────┴─────────────────┴─────────────────┴─────────────────┴─────────────────┴──────────────────────────┴────────────────────┴──────────────────────────┴─────────────────┴───────────────┴──────────────┴────────────────────────────┴──────────────────────┴──────────────────────────┴─────────────────────────┴─────────────────────────────────┴───────────────────────┴───────────────────────────┴──────────────────────┴──────────────┴───────────────────────────┴──────────┴────────────────────────────┴─────────────────────┴────────────────────────┴───────────────────┴─────────────────┴────────────────────────────┴──────────────────────────┴───────────────────┴───────────────────────┴────────────────────┴──────────────────────────┴──────────────────┴────────────────────────┴──────────────────────────┴────────────────────────────┴─────────────────────────────────┴─────────────────────────┴───────────────────┴───────────────────────┴─────────────────────┴────────────────────────┴───────────────────┴──────────────────────────┴─────────────────────────────┴────────────────────────────────┴───────────────────────────┴────────────────────┴───────────────────────┴─────────────────────────────────┴───────────────────────┴─────────────┴──────────────┴────────────────────────────┴───────────────────────┴─────────────────┴─────────────────────┴──────────────────────────┴──────────────────────────────┴─────────────────────────────┴───────────────┴────────────────────────────┴──────────────────────────┴─────────────────────────┴────────────────────┴────────────────────┴───────────────────┴───────────────────┴────────────────────┴──────────────────────┴───────────────────────────┴──────────────────────────┴─────────────────────────────────┴───────────────────────┴───────────────────────────┴───────────────────────────┴───────────────────┴────────────────────┴─────────────────────┴────────────────────────────┴────────────────────────┴───────────────────────┴──────────────────────────┴─────────────────────────────┴────────────────┴───────────────────────┴─────────────────────────┴────────────────────────────┴──────────────────────────┴─────────────────────────────────┴──────────────────────┴─────────────────────────────┴────────────────────────────────┴──────────────────────────┴────────────────────────────────┴────────────────────────────────┴───────────────────────┴──────────────────────────────┴───────────────────────────────┴────────────────────────────┴─────────────────────────┴────────────────────────────────┴─────────────────────┴────────────────────────────┴───────────────────────────┴──────────────────────────────┴───────────────────────┴──────────────────────┴───────────────────┴───────────────┴─────────────────┴──────────────┴──────────────────────────────┴─────────────────────────────┴─────────────────────────────┴─────────────────────────────────┴─────────────────────────────────┴─────────────────────────────────┴─────────────┴────────────────────────┴────────────────────────────┴───────────────────────────────┴───────────────────────────┴─────────────┴─────────────────────┴──────────────────────┴───────────────────────────┴──────────────────────────────┴──────────────┴───────────────────┴──────────────────────────┴────────────────────┴────────────────┴─────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ employername_160M ┃ num_group1 ┃ pmtamount_36A ┃ processingdate_168D ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━┩
│ int64   │ string            │ int64      │ float64       │ string              │
├─────────┼───────────────────┼────────────┼───────────────┼─────────────────────┤
│     357 │ c91b12ff          │          5 │        1100.0 │ 2018-08-08          │
│     357 │ c91b12ff          │          1 │        1200.0 │ 2018-11-28          │
│     357 │ c91b12ff          │          4 │        1200.0 │ 2018-09-10          │
└─────────┴───────────────────┴────────────┴───────────────┴─────────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━━━━┓
┃ case_id ┃ birth_259D ┃ birthdate_87D ┃ childnum_185L ┃ contaddr_district_15M ┃ contaddr_matchlist_1032L ┃ contaddr_smempladdr_334L ┃ contaddr_zipcode_807M ┃ education_927M ┃ empl_employedfrom_271D ┃ empl_employedtotal_800L ┃ empl_industry_691L ┃ empladdr_district_926M ┃ empladdr_zipcode_114M ┃ familystate_447L ┃ gender_992L ┃ housetype_905L ┃ housingtype_772L ┃ incometype_1044T ┃ isreference_387L ┃ language1_981M ┃ mainoccupationinc_384A ┃ maritalst_703L ┃ num_group1 ┃ personindex_1023L ┃ persontype_1072L ┃ persontype_792L ┃ registaddr_district_1083M ┃ registaddr_zipcode_184M ┃ relationshiptoclient_415T ┃ relationshiptoclient_642T ┃ remitter_829L ┃ role_1084L ┃ role_993L ┃ safeguarantyflag_411L ┃ sex_738L ┃ type_25L       ┃
┡━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━━━━━━━┩
│ int64   │ string     │ string        │ float64       │ string                │ boolean                  │ boolean                  │ string                │ string         │ string                 │ string                  │ string             │ string                 │ string                │ string           │ string      │ string         │ string           │ string           │ boolean          │ string         │ float64                │ string         │ int64      │ float64           │ float64          │ float64         │ string                    │ string                  │ string                    │ string                    │ boolean       │ string     │ string    │ boolean               │ string   │ string         │
├─────────┼────────────┼───────────────┼───────────────┼───────────────────────┼──────────────────────────┼──────────────────────────┼───────────────────────┼────────────────┼────────────────────────┼─────────────────────────┼────────────────────┼────────────────────────┼───────────────────────┼──────────────────┼─────────────┼────────────────┼──────────────────┼──────────────────┼──────────────────┼────────────────┼────────────────────────┼────────────────┼────────────┼───────────────────┼──────────────────┼─────────────────┼───────────────────────────┼─────────────────────────┼───────────────────────────┼───────────────────────────┼───────────────┼────────────┼───────────┼───────────────────────┼──────────┼────────────────┤
│       0 │ 1986-07-01 │ NULL          │          NULL │ P88_18_84             │ False                    │ False                    │ P167_100_165          │ P97_36_170     │ 2017-09-15             │ MORE_FIVE               │ OTHER              │ P142_57_166            │ P167_100_165          │ MARRIED          │ NULL        │ NULL           │ NULL             │ SALARIED_GOVT    │ NULL             │ P10_39_147     │                10800.0 │ NULL           │          0 │               0.0 │              1.0 │             1.0 │ P88_18_84                 │ P167_100_165            │ NULL                      │ NULL                      │ NULL          │ CL         │ NULL      │ True                  │ F        │ PRIMARY_MOBILE │
│       0 │ NULL       │ NULL          │          NULL │ a55475b1              │ NULL                     │ NULL                     │ a55475b1              │ a55475b1       │ NULL                   │ NULL                    │ NULL               │ a55475b1               │ a55475b1              │ NULL             │ NULL        │ NULL           │ NULL             │ NULL             │ NULL             │ a55475b1       │                   NULL │ NULL           │          1 │               1.0 │              1.0 │             4.0 │ a55475b1                  │ a55475b1                │ SPOUSE                    │ NULL                      │ False         │ EM         │ NULL      │ NULL                  │ NULL     │ PHONE          │
│       0 │ NULL       │ NULL          │          NULL │ a55475b1              │ NULL                     │ NULL                     │ a55475b1              │ a55475b1       │ NULL                   │ NULL                    │ NULL               │ a55475b1               │ a55475b1              │ NULL             │ NULL        │ NULL           │ NULL             │ NULL             │ NULL             │ a55475b1       │                   NULL │ NULL           │          2 │               2.0 │              4.0 │             5.0 │ a55475b1                  │ a55475b1                │ COLLEAGUE                 │ SPOUSE                    │ False         │ PE         │ NULL      │ NULL                  │ NULL     │ PHONE          │
└─────────┴────────────┴───────────────┴───────────────┴───────────────────────┴──────────────────────────┴──────────────────────────┴───────────────────────┴────────────────┴────────────────────────┴─────────────────────────┴────────────────────┴────────────────────────┴───────────────────────┴──────────────────┴─────────────┴────────────────┴──────────────────┴──────────────────┴──────────────────┴────────────────┴────────────────────────┴────────────────┴────────────┴───────────────────┴──────────────────┴─────────────────┴───────────────────────────┴─────────────────────────┴───────────────────────────┴───────────────────────────┴───────────────┴────────────┴───────────┴───────────────────────┴──────────┴────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ amount_1115A ┃ classificationofcontr_1114M ┃ contractdate_551D ┃ contractmaturitydate_151D ┃ contractst_516M ┃ contracttype_653M ┃ credlmt_1052A ┃ credlmt_228A ┃ credlmt_3940954A ┃ credor_3940957M ┃ credquantity_1099L ┃ credquantity_984L ┃ debtpastduevalue_732A ┃ debtvalue_227A ┃ dpd_550P ┃ dpd_733P ┃ dpdmax_851P ┃ dpdmaxdatemonth_804T ┃ dpdmaxdateyear_742T ┃ installmentamount_644A ┃ installmentamount_833A ┃ instlamount_892A ┃ interesteffectiverate_369L ┃ interestrateyearly_538L ┃ lastupdate_260D ┃ maxdebtpduevalodued_3940955A ┃ num_group1 ┃ numberofinstls_810L ┃ overdueamountmax_950A ┃ overdueamountmaxdatemonth_494T ┃ overdueamountmaxdateyear_432T ┃ periodicityofpmts_997L ┃ periodicityofpmts_997M ┃ pmtdaysoverdue_1135P ┃ pmtmethod_731M ┃ pmtnumpending_403L ┃ purposeofcred_722M ┃ residualamount_1093A ┃ residualamount_127A ┃ residualamount_3940956A ┃ subjectrole_326M ┃ subjectrole_43M ┃ totalamount_503A ┃ totalamount_881A ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━┩
│ int64   │ float64      │ string                      │ string            │ string                    │ string          │ string            │ float64       │ float64      │ float64          │ string          │ float64            │ float64           │ float64               │ float64        │ float64  │ float64  │ float64     │ float64              │ float64             │ float64                │ float64                │ float64          │ float64                    │ float64                 │ string          │ float64                      │ int64      │ float64             │ float64               │ float64                        │ float64                       │ string                 │ string                 │ float64              │ string         │ float64            │ string             │ float64              │ float64             │ float64                 │ string           │ string          │ float64          │ float64          │
├─────────┼──────────────┼─────────────────────────────┼───────────────────┼───────────────────────────┼─────────────────┼───────────────────┼───────────────┼──────────────┼──────────────────┼─────────────────┼────────────────────┼───────────────────┼───────────────────────┼────────────────┼──────────┼──────────┼─────────────┼──────────────────────┼─────────────────────┼────────────────────────┼────────────────────────┼──────────────────┼────────────────────────────┼─────────────────────────┼─────────────────┼──────────────────────────────┼────────────┼─────────────────────┼───────────────────────┼────────────────────────────────┼───────────────────────────────┼────────────────────────┼────────────────────────┼──────────────────────┼────────────────┼────────────────────┼────────────────────┼──────────────────────┼─────────────────────┼─────────────────────────┼──────────────────┼─────────────────┼──────────────────┼──────────────────┤
│     467 │         NULL │ ea6782cc                    │ 2011-06-15        │ 2031-06-13                │ 7241344e        │ 724be82a          │  3.000000e+06 │      10000.0 │     3.000000e+06 │ P164_34_168     │                2.0 │               1.0 │                  NULL │           NULL │      0.0 │      0.0 │        NULL │                 NULL │                NULL │                    0.0 │                  0.000 │             NULL │                       NULL │                    NULL │ 2019-01-20      │                         NULL │          0 │                NULL │                  NULL │                           NULL │                          NULL │ NULL                   │ a55475b1               │                 NULL │ a55475b1       │               NULL │ 96a8fdfe           │                  0.0 │                 0.0 │                    NULL │ fa4f56f1         │ ab3c25cf        │     3.000000e+06 │          10000.0 │
│     467 │         NULL │ ea6782cc                    │ 2019-01-04        │ 2021-08-04                │ 7241344e        │ 724be82a          │          NULL │         NULL │     1.303650e+05 │ P164_34_168     │                1.0 │               2.0 │                  NULL │           NULL │      0.0 │      0.0 │        NULL │                 NULL │                NULL │                    0.0 │              26571.969 │             NULL │                       NULL │                    NULL │ 2019-01-20      │                         NULL │          1 │                NULL │                  NULL │                           NULL │                          NULL │ NULL                   │ a55475b1               │                 NULL │ a55475b1       │               NULL │ 96a8fdfe           │                 NULL │                NULL │                    NULL │ ab3c25cf         │ ab3c25cf        │     7.800000e+04 │         960000.0 │
│     467 │      78000.0 │ ea6782cc                    │ 2016-10-25        │ 2019-10-25                │ 7241344e        │ 4257cbed          │          NULL │         NULL │             NULL │ c5a72b57        │               NULL │              NULL │                   0.0 │      26571.969 │     NULL │     NULL │         0.0 │                 11.0 │              2016.0 │                   NULL │                   NULL │          2898.76 │                       NULL │                    NULL │ 2019-01-10      │                          0.0 │          2 │                36.0 │                   0.0 │                           11.0 │                        2016.0 │ NULL                   │ a0b598e4               │                  0.0 │ e914c86c       │               10.0 │ 96a8fdfe           │                 NULL │                NULL │                    NULL │ a55475b1         │ a55475b1        │             NULL │             NULL │
└─────────┴──────────────┴─────────────────────────────┴───────────────────┴───────────────────────────┴─────────────────┴───────────────────┴───────────────┴──────────────┴──────────────────┴─────────────────┴────────────────────┴───────────────────┴───────────────────────┴────────────────┴──────────┴──────────┴─────────────┴──────────────────────┴─────────────────────┴────────────────────────┴────────────────────────┴──────────────────┴────────────────────────────┴─────────────────────────┴─────────────────┴──────────────────────────────┴────────────┴─────────────────────┴───────────────────────┴────────────────────────────────┴───────────────────────────────┴────────────────────────┴────────────────────────┴──────────────────────┴────────────────┴────────────────────┴────────────────────┴──────────────────────┴─────────────────────┴─────────────────────────┴──────────────────┴─────────────────┴──────────────────┴──────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ case_id ┃ amount_4917619A ┃ deductiondate_4917603D ┃ name_4917606M ┃ num_group1 ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ int64   │ float64         │ string                 │ string        │ int64      │
├─────────┼─────────────────┼────────────────────────┼───────────────┼────────────┤
│   49435 │          6885.0 │ 2019-10-16             │ 6b730375      │          7 │
│   49435 │          6885.0 │ 2019-10-16             │ 6b730375      │          1 │
│   49435 │          6885.0 │ 2019-10-16             │ 6b730375      │          8 │
└─────────┴─────────────────┴────────────────────────┴───────────────┴────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ last180dayaveragebalance_704A ┃ last180dayturnover_1134A ┃ last30dayturnover_651A ┃ num_group1 ┃ openingdate_857D ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━┩
│ int64   │ float64                       │ float64                  │ float64                │ int64      │ string           │
├─────────┼───────────────────────────────┼──────────────────────────┼────────────────────────┼────────────┼──────────────────┤
│     225 │                          NULL │                     NULL │                   NULL │          0 │ 2016-08-16       │
│     331 │                          NULL │                     NULL │                   NULL │          0 │ 2015-03-19       │
│     358 │                          NULL │                     NULL │                   NULL │          0 │ 2014-09-02       │
└─────────┴───────────────────────────────┴──────────────────────────┴────────────────────────┴────────────┴──────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━┓
┃ case_id ┃ actualdpd_943P ┃ annuity_853A ┃ approvaldate_319D ┃ byoccupationinc_3656910L ┃ cancelreason_3545846M ┃ childnum_21L ┃ creationdate_885D ┃ credacc_actualbalance_314A ┃ credacc_credlmt_575A ┃ credacc_maxhisbal_375A ┃ credacc_minhisbal_90A ┃ credacc_status_367L ┃ credacc_transactions_402L ┃ credamount_590A ┃ credtype_587L ┃ currdebt_94A ┃ dateactivated_425D ┃ district_544M ┃ downpmt_134A ┃ dtlastpmt_581D ┃ dtlastpmtallstes_3545839D ┃ education_1138M ┃ employedfrom_700D ┃ familystate_726L ┃ firstnonzeroinstldate_307D ┃ inittransactioncode_279L ┃ isbidproduct_390L ┃ isdebitcard_527L ┃ mainoccupationinc_437A ┃ maxdpdtolerance_577P ┃ num_group1 ┃ outstandingdebt_522A ┃ pmtnum_8L ┃ postype_4733339M ┃ profession_152M ┃ rejectreason_755M ┃ rejectreasonclient_4145042M ┃ revolvingaccount_394A ┃ status_219L ┃ tenor_203L ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━┩
│ int64   │ float64        │ float64      │ string            │ float64                  │ string                │ float64      │ string            │ float64                    │ float64              │ float64                │ float64               │ string              │ float64                   │ float64         │ string        │ float64      │ string             │ string        │ float64      │ string         │ string                    │ string          │ string            │ string           │ string                     │ string                   │ boolean           │ boolean          │ float64                │ float64              │ int64      │ float64              │ float64   │ string           │ string          │ string            │ string                      │ float64               │ string      │ float64    │
├─────────┼────────────────┼──────────────┼───────────────────┼──────────────────────────┼───────────────────────┼──────────────┼───────────────────┼────────────────────────────┼──────────────────────┼────────────────────────┼───────────────────────┼─────────────────────┼───────────────────────────┼─────────────────┼───────────────┼──────────────┼────────────────────┼───────────────┼──────────────┼────────────────┼───────────────────────────┼─────────────────┼───────────────────┼──────────────────┼────────────────────────────┼──────────────────────────┼───────────────────┼──────────────────┼────────────────────────┼──────────────────────┼────────────┼──────────────────────┼───────────┼──────────────────┼─────────────────┼───────────────────┼─────────────────────────────┼───────────────────────┼─────────────┼────────────┤
│   40704 │            0.0 │    7204.6000 │ NULL              │                     NULL │ P94_109_143           │         NULL │ 2018-11-20        │                       NULL │                  0.0 │                   NULL │                  NULL │ NULL                │                      NULL │         54000.0 │ CAL           │         NULL │ NULL               │ P147_6_101    │          0.0 │ NULL           │ NULL                      │ a55475b1        │ NULL              │ NULL             │ 2018-12-20                 │ CASH                     │ False             │ NULL             │                40000.0 │                 NULL │          0 │                 NULL │      12.0 │ P46_145_78       │ a55475b1        │ P198_131_9        │ P94_109_143                 │                  NULL │ D           │       12.0 │
│   40734 │            0.0 │    3870.2000 │ NULL              │                     NULL │ P94_109_143           │         NULL │ 2019-12-26        │                       NULL │                  0.0 │                   NULL │                  NULL │ NULL                │                      NULL │         50000.0 │ CAL           │         NULL │ NULL               │ P111_148_100  │          0.0 │ NULL           │ NULL                      │ a55475b1        │ NULL              │ NULL             │ 2020-01-26                 │ CASH                     │ False             │ NULL             │                50000.0 │                 NULL │          0 │                 NULL │      18.0 │ P149_40_170      │ a55475b1        │ P45_84_106        │ P94_109_143                 │                  NULL │ D           │       18.0 │
│   40737 │            0.0 │    2324.4001 │ NULL              │                      1.0 │ a55475b1              │          0.0 │ 2014-07-17        │                       NULL │                  0.0 │                   NULL │                  NULL │ NULL                │                      NULL │         30000.0 │ CAL           │          0.0 │ NULL               │ a55475b1      │          0.0 │ NULL           │ NULL                      │ P97_36_170      │ 2014-01-15        │ MARRIED          │ 2014-08-17                 │ CASH                     │ False             │ NULL             │                16000.0 │                 NULL │          0 │                  0.0 │      18.0 │ P46_145_78       │ a55475b1        │ a55475b1          │ a55475b1                    │                  NULL │ D           │       18.0 │
└─────────┴────────────────┴──────────────┴───────────────────┴──────────────────────────┴───────────────────────┴──────────────┴───────────────────┴────────────────────────────┴──────────────────────┴────────────────────────┴───────────────────────┴─────────────────────┴───────────────────────────┴─────────────────┴───────────────┴──────────────┴────────────────────┴───────────────┴──────────────┴────────────────┴───────────────────────────┴─────────────────┴───────────────────┴──────────────────┴────────────────────────────┴──────────────────────────┴───────────────────┴──────────────────┴────────────────────────┴──────────────────────┴────────────┴──────────────────────┴───────────┴──────────────────┴─────────────────┴───────────────────┴─────────────────────────────┴───────────────────────┴─────────────┴────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ amount_4527230A ┃ name_4527232M ┃ num_group1 ┃ recorddate_4527225D ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━┩
│ int64   │ float64         │ string        │ int64      │ string              │
├─────────┼─────────────────┼───────────────┼────────────┼─────────────────────┤
│   28631 │       1946.0000 │ f980a1ea      │          2 │ 2019-09-13          │
│   28631 │        711.0000 │ f980a1ea      │          3 │ 2019-09-13          │
│   28631 │       3616.4001 │ f980a1ea      │          0 │ 2019-09-13          │
└─────────┴─────────────────┴───────────────┴────────────┴─────────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ amount_416A ┃ contractenddate_991D ┃ num_group1 ┃ openingdate_313D ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━┩
│ int64   │ float64     │ string               │ int64      │ string           │
├─────────┼─────────────┼──────────────────────┼────────────┼──────────────────┤
│     225 │       0.000 │ NULL                 │          0 │ 2016-08-16       │
│     331 │     260.374 │ 2018-03-18           │          0 │ 2015-03-19       │
│     358 │       0.000 │ NULL                 │          0 │ 2014-09-02       │
└─────────┴─────────────┴──────────────────────┴────────────┴──────────────────┘

┏━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ case_id ┃ collater_typofvalofguarant_298M ┃ collater_typofvalofguarant_407M ┃ collater_valueofguarantee_1124L ┃ collater_valueofguarantee_876L ┃ collaterals_typeofguarante_359M ┃ collaterals_typeofguarante_669M ┃ num_group1 ┃ num_group2 ┃ pmts_dpd_1073P ┃ pmts_dpd_303P ┃ pmts_month_158T ┃ pmts_month_706T ┃ pmts_overdue_1140A ┃ pmts_overdue_1152A ┃ pmts_year_1139T ┃ pmts_year_507T ┃ subjectroles_name_541M ┃ subjectroles_name_838M ┃
┡━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━┩
│ int64   │ string                          │ string                          │ float64                         │ float64                        │ string                          │ string                          │ int64      │ int64      │ float64        │ float64       │ float64         │ float64         │ float64            │ float64            │ float64         │ float64        │ string                 │ string                 │
├─────────┼─────────────────────────────────┼─────────────────────────────────┼─────────────────────────────────┼────────────────────────────────┼─────────────────────────────────┼─────────────────────────────────┼────────────┼────────────┼────────────────┼───────────────┼─────────────────┼─────────────────┼────────────────────┼────────────────────┼─────────────────┼────────────────┼────────────────────────┼────────────────────────┤
│    6683 │ 8fd95e4b                        │ a55475b1                        │                    6.742800e+06 │                           NULL │ a55475b1                        │ 9276e4bb                        │          0 │          0 │           NULL │          NULL │             2.0 │            NULL │               NULL │               NULL │          2017.0 │           NULL │ a55475b1               │ ab3c25cf               │
│    6683 │ 8fd95e4b                        │ a55475b1                        │                    6.700000e+06 │                           NULL │ a55475b1                        │ 0e63c0f0                        │          0 │          1 │           NULL │          NULL │             3.0 │            NULL │               NULL │               NULL │          2017.0 │           NULL │ a55475b1               │ a55475b1               │
│    6683 │ a55475b1                        │ a55475b1                        │                            NULL │                           NULL │ a55475b1                        │ a55475b1                        │          0 │          2 │            0.0 │          NULL │             4.0 │            NULL │                0.0 │               NULL │          2017.0 │           NULL │ a55475b1               │ a55475b1               │
└─────────┴─────────────────────────────────┴─────────────────────────────────┴─────────────────────────────────┴────────────────────────────────┴─────────────────────────────────┴─────────────────────────────────┴────────────┴────────────┴────────────────┴───────────────┴─────────────────┴─────────────────┴────────────────────┴────────────────────┴─────────────────┴────────────────┴────────────────────────┴────────────────────────┘

Where to find columns?

c = {i.name:ibis.read_parquet(i).columns for i in p.glob("*.parquet")}

with pd.option_context('display.max_rows', None):
    fdef=pd.read_csv('home-credit-credit-risk-model-stability/feature_definitions.csv').set_index('Variable')
    lookuptable=(pd.DataFrame([pd.Series({"File":i, "Variable":j}) for i, j in c.items()])
        .explode('Variable')
        .assign(File=lambda x: x["File"].str.replace('\.parquet$','', regex=True))
        .groupby('Variable')
        .agg({"File":lambda x: x.to_list()})
        .join(fdef)
        .reset_index())
    display(lookuptable)

	Variable	File	Description
0	MONTH	[train_base]	NaN
1	WEEK_NUM	[train_base]	NaN
2	actualdpd_943P	[train_applprev_1_0, train_applprev_1_1]	Days Past Due (DPD) of previous contract (actu...
3	actualdpdtolerance_344P	[train_static_0_0, train_static_0_1]	DPD of client with tolerance.
4	addres_district_368M	[train_person_2]	District of the person's address.
5	addres_role_871L	[train_person_2]	Role of person's address.
6	addres_zip_823M	[train_person_2]	Zip code of the address.
7	amount_1115A	[train_credit_bureau_b_1]	Credit amount of the active contract provided ...
8	amount_416A	[train_deposit_1]	Deposit amount.
9	amount_4527230A	[train_tax_registry_a_1]	Tax deductions amount tracked by the governmen...
10	amount_4917619A	[train_tax_registry_b_1]	Tax deductions amount tracked by the governmen...
11	amtdebitincoming_4809443A	[train_other_1]	Incoming debit card transactions amount.
12	amtdebitoutgoing_4809440A	[train_other_1]	Outgoing debit card transactions amount.
13	amtdepositbalance_4809441A	[train_other_1]	Deposit balance of client.
14	amtdepositincoming_4809444A	[train_other_1]	Amount of incoming deposits to client's account.
15	amtdepositoutgoing_4809442A	[train_other_1]	Amount of outgoing deposits from client's acco...
16	amtinstpaidbefduel24m_4187115A	[train_static_0_0, train_static_0_1]	Number of instalments paid before due date in ...
17	annualeffectiverate_199L	[train_credit_bureau_a_1_0, train_credit_burea...	Interest rate of the closed contracts.
18	annualeffectiverate_63L	[train_credit_bureau_a_1_0, train_credit_burea...	Interest rate for the active contracts.
19	annuity_780A	[train_static_0_0, train_static_0_1]	Monthly annuity amount.
20	annuity_853A	[train_applprev_1_0, train_applprev_1_1]	Monthly annuity for previous applications.
21	annuitynextmonth_57A	[train_static_0_0, train_static_0_1]	Next month's amount of annuity.
22	applicationcnt_361L	[train_static_0_0, train_static_0_1]	Number of applications associated with the sam...
23	applications30d_658L	[train_static_0_0, train_static_0_1]	Number of applications made by the client in t...
24	applicationscnt_1086L	[train_static_0_0, train_static_0_1]	Number of applications associated with the sam...
25	applicationscnt_464L	[train_static_0_0, train_static_0_1]	Number of applications made in the last 30 day...
26	applicationscnt_629L	[train_static_0_0, train_static_0_1]	Number of applications with the same employer ...
27	applicationscnt_867L	[train_static_0_0, train_static_0_1]	Number of applications associated with the sam...
28	approvaldate_319D	[train_applprev_1_0, train_applprev_1_1]	Approval Date of Previous Application
29	assignmentdate_238D	[train_static_cb_0]	Tax authority data - date of assignment.
30	assignmentdate_4527235D	[train_static_cb_0]	Tax authority data - Date of assignment.
31	assignmentdate_4955616D	[train_static_cb_0]	Tax authority assignment date.
32	avgdbddpdlast24m_3658932P	[train_static_0_0, train_static_0_1]	Average days past or before due of payment dur...
33	avgdbddpdlast3m_4187120P	[train_static_0_0, train_static_0_1]	Average days past or before due of payment dur...
34	avgdbdtollast24m_4525197P	[train_static_0_0, train_static_0_1]	Average days of payment before due date within...
35	avgdpdtolclosure24_3658938P	[train_static_0_0, train_static_0_1]	Average DPD (days past due) with tolerance wit...
36	avginstallast24m_3658937A	[train_static_0_0, train_static_0_1]	Average instalments paid by the client over th...
37	avglnamtstart24m_4525187A	[train_static_0_0, train_static_0_1]	Average loan amount in the last 24 months.
38	avgmaxdpdlast9m_3716943P	[train_static_0_0, train_static_0_1]	Average Days Past Due (DPD) of the client in l...
39	avgoutstandbalancel6m_4187114A	[train_static_0_0, train_static_0_1]	Average outstanding balance of applicant for t...
40	avgpmtlast12m_4525200A	[train_static_0_0, train_static_0_1]	Average of payments made by the client in the ...
41	bankacctype_710L	[train_static_0_0, train_static_0_1]	Type of applicant's bank account.
42	birth_259D	[train_person_1]	Date of birth of the person.
43	birthdate_574D	[train_static_cb_0]	Client's date of birth (credit bureau data).
44	birthdate_87D	[train_person_1]	Birth date of the person.
45	byoccupationinc_3656910L	[train_applprev_1_0, train_applprev_1_1]	Applicant's income from previous applications.
46	cacccardblochreas_147M	[train_applprev_2]	Card blocking reason.
47	cancelreason_3545846M	[train_applprev_1_0, train_applprev_1_1]	Application cancellation reason.
48	cardtype_51L	[train_static_0_0, train_static_0_1]	Type of credit card.
49	case_id	[train_person_2, train_applprev_2, train_credi...	NaN
50	childnum_185L	[train_person_1]	Number of children of the applicant.
51	childnum_21L	[train_applprev_1_0, train_applprev_1_1]	Number of children in the previous application.
52	classificationofcontr_1114M	[train_credit_bureau_b_1]	Classificiation of the active contract.
53	classificationofcontr_13M	[train_credit_bureau_a_1_0, train_credit_burea...	Classificiation of the active contract.
54	classificationofcontr_400M	[train_credit_bureau_a_1_0, train_credit_burea...	Classificiation of the closed contract.
55	clientscnt12m_3712952L	[train_static_0_0, train_static_0_1]	Number of clients that have used the same mobi...
56	clientscnt3m_3712950L	[train_static_0_0, train_static_0_1]	Number of clients who have the same mobile pho...
57	clientscnt6m_3712949L	[train_static_0_0, train_static_0_1]	Total number of clients who have used the same...
58	clientscnt_100L	[train_static_0_0, train_static_0_1]	Number of applications with matching employer'...
59	clientscnt_1022L	[train_static_0_0, train_static_0_1]	Number of clients sharing the same mobile phone.
60	clientscnt_1071L	[train_static_0_0, train_static_0_1]	Number of applications where the alternative p...
61	clientscnt_1130L	[train_static_0_0, train_static_0_1]	Number of applications where client's phone nu...
62	clientscnt_136L	[train_static_0_0, train_static_0_1]	Number of applications associated with same em...
63	clientscnt_157L	[train_static_0_0, train_static_0_1]	Number of clients whose employer has the same ...
64	clientscnt_257L	[train_static_0_0, train_static_0_1]	Number of clients that share an alternative ph...
65	clientscnt_304L	[train_static_0_0, train_static_0_1]	Number of clients with the same phone number.
66	clientscnt_360L	[train_static_0_0, train_static_0_1]	Number of clients that have the same alternati...
67	clientscnt_493L	[train_static_0_0, train_static_0_1]	Number of clients with matching phone numbers ...
68	clientscnt_533L	[train_static_0_0, train_static_0_1]	Number of clients with same client's and alter...
69	clientscnt_887L	[train_static_0_0, train_static_0_1]	Number of clients sharing the same employer's ...
70	clientscnt_946L	[train_static_0_0, train_static_0_1]	Number of clients with matching mobile and emp...
71	cntincpaycont9m_3716944L	[train_static_0_0, train_static_0_1]	Number of incoming payments in the past 9 months.
72	cntpmts24_3658933L	[train_static_0_0, train_static_0_1]	Number of months with any incoming payment in ...
73	collater_typofvalofguarant_298M	[train_credit_bureau_a_2_4, train_credit_burea...	Collateral valuation type (active contract).
74	collater_typofvalofguarant_407M	[train_credit_bureau_a_2_4, train_credit_burea...	Collateral valuation type (closed contract).
75	collater_valueofguarantee_1124L	[train_credit_bureau_a_2_4, train_credit_burea...	Value of collateral for active contract.
76	collater_valueofguarantee_876L	[train_credit_bureau_a_2_4, train_credit_burea...	Value of collateral for closed contract.
77	collaterals_typeofguarante_359M	[train_credit_bureau_a_2_4, train_credit_burea...	Type of collateral that was used as a guarante...
78	collaterals_typeofguarante_669M	[train_credit_bureau_a_2_4, train_credit_burea...	Collateral type for the active contract.
79	commnoinclast6m_3546845L	[train_static_0_0, train_static_0_1]	Number of communications indicating low income...
80	contaddr_district_15M	[train_person_1]	Zip code of a contact person's address.
81	contaddr_matchlist_1032L	[train_person_1]	Indicates whether the contact address is found...
82	contaddr_smempladdr_334L	[train_person_1]	Indicates whether the contact address is the s...
83	contaddr_zipcode_807M	[train_person_1]	Zip code of contact address.
84	contractdate_551D	[train_credit_bureau_b_1]	Contract date of the active contract
85	contractenddate_991D	[train_deposit_1]	End date of deposit contract.
86	contractmaturitydate_151D	[train_credit_bureau_b_1]	End date of active contract.
87	contractssum_5085716L	[train_static_cb_0]	Total sum of values of contracts retrieved fro...
88	contractst_516M	[train_credit_bureau_b_1]	Contract status.
89	contractst_545M	[train_credit_bureau_a_1_0, train_credit_burea...	Contract status.
90	contractst_964M	[train_credit_bureau_a_1_0, train_credit_burea...	Contract status of terminated credit contract.
91	contractsum_5085717L	[train_credit_bureau_a_1_0, train_credit_burea...	Sum of other contract values.
92	contracttype_653M	[train_credit_bureau_b_1]	Contract Type
93	conts_role_79M	[train_person_2]	Type of contact role of a person.
94	conts_type_509L	[train_applprev_2]	Person contact type in previous application.
95	creationdate_885D	[train_applprev_1_0, train_applprev_1_1]	Date when previous application was created.
96	credacc_actualbalance_314A	[train_applprev_1_0, train_applprev_1_1]	Actual balance on credit account.
97	credacc_cards_status_52L	[train_applprev_2]	Card status of the previous credit account.
98	credacc_credlmt_575A	[train_applprev_1_0, train_applprev_1_1]	Credit card credit limit provided for previous...
99	credacc_maxhisbal_375A	[train_applprev_1_0, train_applprev_1_1]	Maximal historical balance of previous credit ...
100	credacc_minhisbal_90A	[train_applprev_1_0, train_applprev_1_1]	Minimum historical balance of previous credit ...
101	credacc_status_367L	[train_applprev_1_0, train_applprev_1_1]	Account status of previous credit applications.
102	credacc_transactions_402L	[train_applprev_1_0, train_applprev_1_1]	Number of transactions made with the previous ...
103	credamount_590A	[train_applprev_1_0, train_applprev_1_1]	Loan amount or card limit of previous applicat...
104	credamount_770A	[train_static_0_0, train_static_0_1]	Loan amount or credit card limit.
105	credlmt_1052A	[train_credit_bureau_b_1]	Credit limit of an active loan.
106	credlmt_228A	[train_credit_bureau_b_1]	Credit limit for closed loans.
107	credlmt_230A	[train_credit_bureau_a_1_0, train_credit_burea...	Credit limit of the closed credit contracts fr...
108	credlmt_3940954A	[train_credit_bureau_b_1]	Credit limit for active loan.
109	credlmt_935A	[train_credit_bureau_a_1_0, train_credit_burea...	Credit limit for active loan.
110	credor_3940957M	[train_credit_bureau_b_1]	Creditor's name
111	credquantity_1099L	[train_credit_bureau_b_1]	Number of credits in credit bureau
112	credquantity_984L	[train_credit_bureau_b_1]	Number of closed credits in credit bureau.
113	credtype_322L	[train_static_0_0, train_static_0_1]	Type of credit.
114	credtype_587L	[train_applprev_1_0, train_applprev_1_1]	Credit type of previous application.
115	currdebt_22A	[train_static_0_0, train_static_0_1]	Current debt amount of the client.
116	currdebt_94A	[train_applprev_1_0, train_applprev_1_1]	Previous application's current debt.
117	currdebtcredtyperange_828A	[train_static_0_0, train_static_0_1]	Current amount of debt of the applicant.
118	date_decision	[train_base]	NaN
119	dateactivated_425D	[train_applprev_1_0, train_applprev_1_1]	Contract activation date of the applicant's pr...
120	datefirstoffer_1144D	[train_static_0_0, train_static_0_1]	Date of first customer relationship management...
121	datelastinstal40dpd_247D	[train_static_0_0, train_static_0_1]	Date of last instalment that was more than 40 ...
122	datelastunpaid_3546854D	[train_static_0_0, train_static_0_1]	Date of the last unpaid instalment.
123	dateofbirth_337D	[train_static_cb_0]	Client's date of birth.
124	dateofbirth_342D	[train_static_cb_0]	Client's date of birth.
125	dateofcredend_289D	[train_credit_bureau_a_1_0, train_credit_burea...	End date of an active credit contract.
126	dateofcredend_353D	[train_credit_bureau_a_1_0, train_credit_burea...	End date of a closed credit contract.
127	dateofcredstart_181D	[train_credit_bureau_a_1_0, train_credit_burea...	Date when the credit contract was closed.
128	dateofcredstart_739D	[train_credit_bureau_a_1_0, train_credit_burea...	Start date of a closed credit contract.
129	dateofrealrepmt_138D	[train_credit_bureau_a_1_0, train_credit_burea...	Date of credit's closure (contract termination...
130	days120_123L	[train_static_cb_0]	Number of credit bureau queries for the last 1...
131	days180_256L	[train_static_cb_0]	Number of credit bureau queries for last 180 d...
132	days30_165L	[train_static_cb_0]	Number of credit bureau queries for the last 3...
133	days360_512L	[train_static_cb_0]	Number of Credit Bureau queries for last 360 d...
134	days90_310L	[train_static_cb_0]	Number of credit bureau queries for the last 9...
135	daysoverduetolerancedd_3976961L	[train_static_0_0, train_static_0_1]	Number of days that past after the due date (w...
136	debtoutstand_525A	[train_credit_bureau_a_1_0, train_credit_burea...	Outstanding amount of existing contract.
137	debtoverdue_47A	[train_credit_bureau_a_1_0, train_credit_burea...	Amount that is currently past due on a client'...
138	debtpastduevalue_732A	[train_credit_bureau_b_1]	Amount of unpaid debt for existing contracts.
139	debtvalue_227A	[train_credit_bureau_b_1]	Outstanding amount for existing debt contracts.
140	deductiondate_4917603D	[train_tax_registry_b_1]	Tax deduction date.
141	deferredmnthsnum_166L	[train_static_0_0, train_static_0_1]	Number of deferred months.
142	description_351M	[train_credit_bureau_a_1_0, train_credit_burea...	Categorization of clients by credit bureau.
143	description_5085714M	[train_static_cb_0]	Categorization of clients by credit bureau.
144	disbursedcredamount_1113A	[train_static_0_0, train_static_0_1]	Disbursed credit amount after consolidation.
145	disbursementtype_67L	[train_static_0_0, train_static_0_1]	Type of disbursement.
146	district_544M	[train_applprev_1_0, train_applprev_1_1]	District of the address used in the previous l...
147	downpmt_116A	[train_static_0_0, train_static_0_1]	Amount of downpayment.
148	downpmt_134A	[train_applprev_1_0, train_applprev_1_1]	Previous application downpayment amount.
149	dpd_550P	[train_credit_bureau_b_1]	The number of days past due for active loans w...
150	dpd_733P	[train_credit_bureau_b_1]	Days past due (DPD) for guaranteed loans that ...
151	dpdmax_139P	[train_credit_bureau_a_1_0, train_credit_burea...	Maximal days past due for active contract.
152	dpdmax_757P	[train_credit_bureau_a_1_0, train_credit_burea...	Maximum days past due for a closed contract.
153	dpdmax_851P	[train_credit_bureau_b_1]	Maximal past due days for active contracts in ...
154	dpdmaxdatemonth_442T	[train_credit_bureau_a_1_0, train_credit_burea...	Max DPD occurrence month for terminated contra...
155	dpdmaxdatemonth_804T	[train_credit_bureau_b_1]	Month when the maximum Day Past Due (DPD) occu...
156	dpdmaxdatemonth_89T	[train_credit_bureau_a_1_0, train_credit_burea...	Month when maximum days past due occurred on t...
157	dpdmaxdateyear_596T	[train_credit_bureau_a_1_0, train_credit_burea...	Year when maximum Days Past Due (DPD) occurred...
158	dpdmaxdateyear_742T	[train_credit_bureau_b_1]	Year of the maximum Days Past Due (DPD) on an ...
159	dpdmaxdateyear_896T	[train_credit_bureau_a_1_0, train_credit_burea...	Year of maximum Days Past Due of closed contra...
160	dtlastpmt_581D	[train_applprev_1_0, train_applprev_1_1]	Date of last payment made by the applicant.
161	dtlastpmtallstes_3545839D	[train_applprev_1_0, train_applprev_1_1]	Date of the applicant's last payment.
162	dtlastpmtallstes_4499206D	[train_static_0_0, train_static_0_1]	Date of last payment made by the applicant.
163	education_1103M	[train_static_cb_0]	Level of education of the client provided by e...
164	education_1138M	[train_applprev_1_0, train_applprev_1_1]	Applicant's education level from their previou...
165	education_88M	[train_static_cb_0]	Education level of the client.
166	education_927M	[train_person_1]	Education level of the person.
167	eir_270L	[train_static_0_0, train_static_0_1]	Interest rate.
168	empl_employedfrom_271D	[train_person_1]	Start date of employment.
169	empl_employedtotal_800L	[train_person_1]	Employment length of a person.
170	empl_industry_691L	[train_person_1]	Employment Industry of the person.
171	empladdr_district_926M	[train_person_1]	District where the employer's address is located.
172	empladdr_zipcode_114M	[train_person_1]	Zipcode of employer's address.
173	employedfrom_700D	[train_applprev_1_0, train_applprev_1_1]	Employment start date from the previous applic...
174	employername_160M	[train_tax_registry_c_1]	Employer's name.
175	empls_economicalst_849M	[train_person_2]	The economical status of the person (num_group...
176	empls_employedfrom_796D	[train_person_2]	Start of employment (num_group1 - person, num_...
177	empls_employer_name_740M	[train_person_2]	Employer's name (num_group1 - person, num_grou...
178	equalitydataagreement_891L	[train_static_0_0, train_static_0_1]	Flag indicating sudden changes in client's soc...
179	equalityempfrom_62L	[train_static_0_0, train_static_0_1]	Flag indicating a sudden change in the client'...
180	familystate_447L	[train_person_1]	Family state of the person.
181	familystate_726L	[train_applprev_1_0, train_applprev_1_1]	Family State in previous application of applic...
182	financialinstitution_382M	[train_credit_bureau_a_1_0, train_credit_burea...	Name of financial institution that is linked t...
183	financialinstitution_591M	[train_credit_bureau_a_1_0, train_credit_burea...	Financial institution name of the active contr...
184	firstclxcampaign_1125D	[train_static_0_0, train_static_0_1]	Date of the client's first campaign.
185	firstdatedue_489D	[train_static_0_0, train_static_0_1]	Date of the first due date.
186	firstnonzeroinstldate_307D	[train_applprev_1_0, train_applprev_1_1]	Date of first instalment in the previous appli...
187	firstquarter_103L	[train_static_cb_0]	Number of results obtained from credit bureau ...
188	for3years_128L	[train_static_cb_0]	Number of rejected applications in the past 3 ...
189	for3years_504L	[train_static_cb_0]	Client's credit history data over the last thr...
190	for3years_584L	[train_static_cb_0]	Number of cancellations in the last 3 years.
191	formonth_118L	[train_static_cb_0]	Number of rejections in a month.
192	formonth_206L	[train_static_cb_0]	Number of cancelations in the previous month.
193	formonth_535L	[train_static_cb_0]	Credit history for the last month.
194	forquarter_1017L	[train_static_cb_0]	Number of cancellations recorded in the credit...
195	forquarter_462L	[train_static_cb_0]	Number of credit applications that were reject...
196	forquarter_634L	[train_static_cb_0]	Credit history for the last quarter.
197	fortoday_1092L	[train_static_cb_0]	Client's credit history for today.
198	forweek_1077L	[train_static_cb_0]	Number of cancelations in the last week.
199	forweek_528L	[train_static_cb_0]	Credit history for the last week.
200	forweek_601L	[train_static_cb_0]	Number of rejected applications in the last week.
201	foryear_618L	[train_static_cb_0]	Number of application rejections in the previo...
202	foryear_818L	[train_static_cb_0]	Number of cancelations that occurred in last y...
203	foryear_850L	[train_static_cb_0]	Credit history for the last year.
204	fourthquarter_440L	[train_static_cb_0]	Number of results in fourth quarter.
205	gender_992L	[train_person_1]	Gender of a person.
206	homephncnt_628L	[train_static_0_0, train_static_0_1]	Number of distinct home phones on client's app...
207	housetype_905L	[train_person_1]	House type of the person.
208	housingtype_772L	[train_person_1]	Type of housing of the person.
209	incometype_1044T	[train_person_1]	Type of income of the person
210	inittransactionamount_650A	[train_static_0_0, train_static_0_1]	Initial transaction amount of the credit appli...
211	inittransactioncode_186L	[train_static_0_0, train_static_0_1]	Transaction type of the initial credit transac...
212	inittransactioncode_279L	[train_applprev_1_0, train_applprev_1_1]	Type of the initial transaction made in the pr...
213	installmentamount_644A	[train_credit_bureau_b_1]	Instalment amount of a closed and secured cred...
214	installmentamount_833A	[train_credit_bureau_b_1]	Instalment amount for a secured and active con...
215	instlamount_768A	[train_credit_bureau_a_1_0, train_credit_burea...	Instalment amount for the active contract in c...
216	instlamount_852A	[train_credit_bureau_a_1_0, train_credit_burea...	Instalment amount for closed contract.
217	instlamount_892A	[train_credit_bureau_b_1]	Instalment amount for active credit contract.
218	interesteffectiverate_369L	[train_credit_bureau_b_1]	Interest rate on active contract.
219	interestrate_311L	[train_static_0_0, train_static_0_1]	The interest rate of the active credit contract.
220	interestrate_508L	[train_credit_bureau_a_1_0, train_credit_burea...	Interest rate for a closed contract in the cre...
221	interestrategrace_34L	[train_static_0_0, train_static_0_1]	Interest rate during the grace period.
222	interestrateyearly_538L	[train_credit_bureau_b_1]	Annual interest rate for existing contract obt...
223	isbidproduct_1095L	[train_static_0_0, train_static_0_1]	Flag indicating if the product is a cross-sell.
224	isbidproduct_390L	[train_applprev_1_0, train_applprev_1_1]	Flag for determining if the product is a cross...
225	isbidproductrequest_292L	[train_static_0_0, train_static_0_1]	Flag indicating if the product is a cross-sell.
226	isdebitcard_527L	[train_applprev_1_0, train_applprev_1_1]	Previous application flag indicating if produc...
227	isdebitcard_729L	[train_static_0_0, train_static_0_1]	Flag indicating if the product is a debit card.
228	isreference_387L	[train_person_1]	Flag indicating whether the person is a refere...
229	language1_981M	[train_person_1]	The primary language of the person.
230	last180dayaveragebalance_704A	[train_debitcard_1]	Average balance on debit card in the last 180 ...
231	last180dayturnover_1134A	[train_debitcard_1]	Debit card's turnover within the last 180 days.
232	last30dayturnover_651A	[train_debitcard_1]	Debit card turnover for the last 30 days.
233	lastactivateddate_801D	[train_static_0_0, train_static_0_1]	Contract activation date for previous applicat...
234	lastapplicationdate_877D	[train_static_0_0, train_static_0_1]	Date of previous customer's application.
235	lastapprcommoditycat_1041M	[train_static_0_0, train_static_0_1]	Commodity category of the last loan applicatio...
236	lastapprcommoditytypec_5251766M	[train_static_0_0, train_static_0_1]	Commodity type of the last application.
237	lastapprcredamount_781A	[train_static_0_0, train_static_0_1]	Credit amount from the client's last application.
238	lastapprdate_640D	[train_static_0_0, train_static_0_1]	Date of approval on client's most recent previ...
239	lastcancelreason_561M	[train_static_0_0, train_static_0_1]	Cancellation reason of the last application.
240	lastdelinqdate_224D	[train_static_0_0, train_static_0_1]	Date of the last delinquency occurrence.
241	lastdependentsnum_448L	[train_static_0_0, train_static_0_1]	Number of dependents in the client's last loan...
242	lastotherinc_902A	[train_static_0_0, train_static_0_1]	Amount of other income reported by the client ...
243	lastotherlnsexpense_631A	[train_static_0_0, train_static_0_1]	Monthly expenses on other loans from the last ...
244	lastrejectcommoditycat_161M	[train_static_0_0, train_static_0_1]	Category of commodity in the applicant's last ...
245	lastrejectcommodtypec_5251769M	[train_static_0_0, train_static_0_1]	Commodity type of the last rejected application.
246	lastrejectcredamount_222A	[train_static_0_0, train_static_0_1]	Credit amount on last rejected application.
247	lastrejectdate_50D	[train_static_0_0, train_static_0_1]	Date of most recent rejected application by th...
248	lastrejectreason_759M	[train_static_0_0, train_static_0_1]	Reason for rejection on the most recent reject...
249	lastrejectreasonclient_4145040M	[train_static_0_0, train_static_0_1]	Reason for the client's last loan rejection.
250	lastrepayingdate_696D	[train_static_0_0, train_static_0_1]	Date of the last payment made by the applicant.
251	lastst_736L	[train_static_0_0, train_static_0_1]	Status of the client's previous credit applica...
252	lastupdate_1112D	[train_credit_bureau_a_1_0, train_credit_burea...	Date of last update for an active contract fro...
253	lastupdate_260D	[train_credit_bureau_b_1]	Last update date for the active contracts.
254	lastupdate_388D	[train_credit_bureau_a_1_0, train_credit_burea...	Date of last update for a closed contract in t...
255	maininc_215A	[train_static_0_0, train_static_0_1]	Client's primary income amount.
256	mainoccupationinc_384A	[train_person_1]	Amount of the main income of the client.
257	mainoccupationinc_437A	[train_applprev_1_0, train_applprev_1_1]	Client's main income amount in their previous ...
258	maritalst_385M	[train_static_cb_0]	Marital status of the client.
259	maritalst_703L	[train_person_1]	Marital status of the client.
260	maritalst_893M	[train_static_cb_0]	Marital status of the client
261	mastercontrelectronic_519L	[train_static_0_0, train_static_0_1]	Flag indicating the existence of the master co...
262	mastercontrexist_109L	[train_static_0_0, train_static_0_1]	Flag indicating whether or not the applicant h...
263	maxannuity_159A	[train_static_0_0, train_static_0_1]	Maximum annuity previously obtained by client.
264	maxannuity_4075009A	[train_static_0_0, train_static_0_1]	Maximal annuity offered to the client in the c...
265	maxdbddpdlast1m_3658939P	[train_static_0_0, train_static_0_1]	Maximum number of days past due in the last mo...
266	maxdbddpdtollast12m_3658940P	[train_static_0_0, train_static_0_1]	Maximum number of days past due in last 12 mon...
267	maxdbddpdtollast6m_4187119P	[train_static_0_0, train_static_0_1]	Maximum number of days past due in last 6 mont...
268	maxdebt4_972A	[train_static_0_0, train_static_0_1]	Maximal principal debt of the client in the hi...
269	maxdebtpduevalodued_3940955A	[train_credit_bureau_b_1]	Days past due at the time of the maximum debt.
270	maxdpdfrom6mto36m_3546853P	[train_static_0_0, train_static_0_1]	Maximum Days Past Due (DPD) in the period rang...
271	maxdpdinstldate_3546855D	[train_static_0_0, train_static_0_1]	Date of instalment on which client was most da...
272	maxdpdinstlnum_3546846P	[train_static_0_0, train_static_0_1]	Instalment number of which client was most day...
273	maxdpdlast12m_727P	[train_static_0_0, train_static_0_1]	Maximum days past due in the past 12 months.
274	maxdpdlast24m_143P	[train_static_0_0, train_static_0_1]	Maximal days past due in the last 24 months.
275	maxdpdlast3m_392P	[train_static_0_0, train_static_0_1]	Maximum number of days past due in last 3 months.
276	maxdpdlast6m_474P	[train_static_0_0, train_static_0_1]	Maximum days past due in the last 6 months.
277	maxdpdlast9m_1059P	[train_static_0_0, train_static_0_1]	Maximum days past due in last 9 months.
278	maxdpdtolerance_374P	[train_static_0_0, train_static_0_1]	Maximum number of days past due (with tolerance).
279	maxdpdtolerance_577P	[train_applprev_1_0, train_applprev_1_1]	Maximum DPD with tolerance (on previous applic...
280	maxinstallast24m_3658928A	[train_static_0_0, train_static_0_1]	Maximum instalment in the last 24 months
281	maxlnamtstart6m_4525199A	[train_static_0_0, train_static_0_1]	Maximum loan amount started in the last 6 months.
282	maxoutstandbalancel12m_4187113A	[train_static_0_0, train_static_0_1]	Maximum outstanding balance in the last 12 mon...
283	maxpmtlast3m_4525190A	[train_static_0_0, train_static_0_1]	Maximum payment made by the client in the last...
284	mindbddpdlast24m_3658935P	[train_static_0_0, train_static_0_1]	Minimum days past due (or days before due) in ...
285	mindbdtollast24m_4525191P	[train_static_0_0, train_static_0_1]	Minimum days before due in last 24 months.
286	mobilephncnt_593L	[train_static_0_0, train_static_0_1]	Number of persons with the same mobile phone n...
287	monthlyinstlamount_332A	[train_credit_bureau_a_1_0, train_credit_burea...	Monthly instalment amount for active contract.
288	monthlyinstlamount_674A	[train_credit_bureau_a_1_0, train_credit_burea...	Monthly amount of instalment payment on a clos...
289	monthsannuity_845L	[train_static_0_0, train_static_0_1]	Monthly annuity amount for the applicant.
290	name_4527232M	[train_tax_registry_a_1]	Name of employer.
291	name_4917606M	[train_tax_registry_b_1]	Name of employer.
292	nominalrate_281L	[train_credit_bureau_a_1_0, train_credit_burea...	Interest rate of the active contract.
293	nominalrate_498L	[train_credit_bureau_a_1_0, train_credit_burea...	Interest rate for closed contract.
294	num_group1	[train_person_2, train_applprev_2, train_credi...	NaN
295	num_group2	[train_person_2, train_applprev_2, train_credi...	NaN
296	numactivecreds_622L	[train_static_0_0, train_static_0_1]	Number of active credits.
297	numactivecredschannel_414L	[train_static_0_0, train_static_0_1]	Number of active credits.
298	numactiverelcontr_750L	[train_static_0_0, train_static_0_1]	Number of active revolving credits.
299	numberofcontrsvalue_258L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of active contracts in credit bureau.
300	numberofcontrsvalue_358L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of closed credit contracts.
301	numberofinstls_229L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of instalments on closed contract.
302	numberofinstls_320L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of instalments of the active contract.
303	numberofinstls_810L	[train_credit_bureau_b_1]	Number of instalments for the active contract.
304	numberofoutstandinstls_520L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of outstanding instalment for closed co...
305	numberofoutstandinstls_59L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of outstanding instalments for the acti...
306	numberofoverdueinstlmax_1039L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of outstanding instalments for active c...
307	numberofoverdueinstlmax_1151L	[train_credit_bureau_a_1_0, train_credit_burea...	Maximum number of past due installments for a ...
308	numberofoverdueinstlmaxdat_148D	[train_credit_bureau_a_1_0, train_credit_burea...	Date of maximum number of past due instalments...
309	numberofoverdueinstlmaxdat_641D	[train_credit_bureau_a_1_0, train_credit_burea...	Date of maximum number of past due instalments...
310	numberofoverdueinstls_725L	[train_credit_bureau_a_1_0, train_credit_burea...	Maximum number of past due instalments for an ...
311	numberofoverdueinstls_834L	[train_credit_bureau_a_1_0, train_credit_burea...	Number of past due instalments for a closed co...
312	numberofqueries_373L	[train_static_cb_0]	Number of queries to credit bureau.
313	numcontrs3months_479L	[train_static_0_0, train_static_0_1]	Number of contracts in last 3 months.
314	numincomingpmts_3546848L	[train_static_0_0, train_static_0_1]	Number of incoming payments.
315	numinstlallpaidearly3d_817L	[train_static_0_0, train_static_0_1]	Number of instalments paid at least 3 days pri...
316	numinstls_657L	[train_static_0_0, train_static_0_1]	Number of instalments.
317	numinstlsallpaid_934L	[train_static_0_0, train_static_0_1]	Number of paid instalments.
318	numinstlswithdpd10_728L	[train_static_0_0, train_static_0_1]	Number of instalments that were overdue for 10...
319	numinstlswithdpd5_4187116L	[train_static_0_0, train_static_0_1]	Number of instalments that were overdue by at ...
320	numinstlswithoutdpd_562L	[train_static_0_0, train_static_0_1]	Number of instalments that were not past due d...
321	numinstmatpaidtearly2d_4499204L	[train_static_0_0, train_static_0_1]	Number of instalments that have been paid more...
322	numinstpaid_4499208L	[train_static_0_0, train_static_0_1]	Number of paid instalments.
323	numinstpaidearly3d_3546850L	[train_static_0_0, train_static_0_1]	Number of instalments paid more than three day...
324	numinstpaidearly3dest_4493216L	[train_static_0_0, train_static_0_1]	Number of instalments that have been paid more...
325	numinstpaidearly5d_1087L	[train_static_0_0, train_static_0_1]	Number of instalments paid more than 5 days pr...
326	numinstpaidearly5dest_4493211L	[train_static_0_0, train_static_0_1]	Number of instalments that were paid more than...
327	numinstpaidearly5dobd_4499205L	[train_static_0_0, train_static_0_1]	Number of installments paid more than 5 days p...
328	numinstpaidearly_338L	[train_static_0_0, train_static_0_1]	Number of installments paid prior to the due d...
329	numinstpaidearlyest_4493214L	[train_static_0_0, train_static_0_1]	Number of instalments paid before the due date.
330	numinstpaidlastcontr_4325080L	[train_static_0_0, train_static_0_1]	Number of paid installments from the client's ...
331	numinstpaidlate1d_3546852L	[train_static_0_0, train_static_0_1]	Number of instalments paid more than 1 day pas...
332	numinstregularpaid_973L	[train_static_0_0, train_static_0_1]	Number of fully paid regular installments in t...
333	numinstregularpaidest_4493210L	[train_static_0_0, train_static_0_1]	Number of fully paid regular installments on c...
334	numinsttopaygr_769L	[train_static_0_0, train_static_0_1]	Number of unpaid instalments.
335	numinsttopaygrest_4493213L	[train_static_0_0, train_static_0_1]	Number of unpaid instalments.
336	numinstunpaidmax_3546851L	[train_static_0_0, train_static_0_1]	Maximum number of unpaid instalments.
337	numinstunpaidmaxest_4493212L	[train_static_0_0, train_static_0_1]	Maximum number of unpaid instalments.
338	numnotactivated_1143L	[train_static_0_0, train_static_0_1]	Number of non-activated credits.
339	numpmtchanneldd_318L	[train_static_0_0, train_static_0_1]	Number of previous loan contracts for the appl...
340	numrejects9m_859L	[train_static_0_0, train_static_0_1]	Number of credit applications that were reject...
341	opencred_647L	[train_static_0_0, train_static_0_1]	Number of active loans from the previous appli...
342	openingdate_313D	[train_deposit_1]	Deposit account opening date.
343	openingdate_857D	[train_debitcard_1]	Debit card opening date.
344	outstandingamount_354A	[train_credit_bureau_a_1_0, train_credit_burea...	Outstanding amount for closed credit contract ...
345	outstandingamount_362A	[train_credit_bureau_a_1_0, train_credit_burea...	Active contract's outstanding amount.
346	outstandingdebt_522A	[train_applprev_1_0, train_applprev_1_1]	Amount of outstanding debt on the client's pre...
347	overdueamount_31A	[train_credit_bureau_a_1_0, train_credit_burea...	Past due amount for a closed contract.
348	overdueamount_659A	[train_credit_bureau_a_1_0, train_credit_burea...	Past due amount for active contract.
349	overdueamountmax2_14A	[train_credit_bureau_a_1_0, train_credit_burea...	Maximal past due amount for an active contract.
350	overdueamountmax2_398A	[train_credit_bureau_a_1_0, train_credit_burea...	Maximal overdue amount for a closed contract.
351	overdueamountmax2date_1002D	[train_credit_bureau_a_1_0, train_credit_burea...	Date of maximal past due amount for a closed c...
352	overdueamountmax2date_1142D	[train_credit_bureau_a_1_0, train_credit_burea...	Date of maximal past due amount for an active ...
353	overdueamountmax_155A	[train_credit_bureau_a_1_0, train_credit_burea...	Maximal past due amount for active contract.
354	overdueamountmax_35A	[train_credit_bureau_a_1_0, train_credit_burea...	Maximal past due amount for a closed contract.
355	overdueamountmax_950A	[train_credit_bureau_b_1]	Maximal past due amount for active contract.
356	overdueamountmaxdatemonth_284T	[train_credit_bureau_a_1_0, train_credit_burea...	Month when the maximum past due amount occurre...
357	overdueamountmaxdatemonth_365T	[train_credit_bureau_a_1_0, train_credit_burea...	Month when maximum past due amount occurred fo...
358	overdueamountmaxdatemonth_494T	[train_credit_bureau_b_1]	Month when the maximum past due amount was rec...
359	overdueamountmaxdateyear_2T	[train_credit_bureau_a_1_0, train_credit_burea...	Year when the maximum past due amount occurred...
360	overdueamountmaxdateyear_432T	[train_credit_bureau_b_1]	Year when max past due amount occurred for act...
361	overdueamountmaxdateyear_994T	[train_credit_bureau_a_1_0, train_credit_burea...	Year when maximum past due amount occurred for...
362	paytype1st_925L	[train_static_0_0, train_static_0_1]	Type of first payment of the client.
363	paytype_783L	[train_static_0_0, train_static_0_1]	Type of payment.
364	payvacationpostpone_4187118D	[train_static_0_0, train_static_0_1]	Date of last payment holiday instalment.
365	pctinstlsallpaidearl3d_427L	[train_static_0_0, train_static_0_1]	Percentage of installments paid at least 3 day...
366	pctinstlsallpaidlat10d_839L	[train_static_0_0, train_static_0_1]	Percentage of installments that were paid 10 o...
367	pctinstlsallpaidlate1d_3546856L	[train_static_0_0, train_static_0_1]	Percentage of installments that are paid 1 or ...
368	pctinstlsallpaidlate4d_3546849L	[train_static_0_0, train_static_0_1]	Percentage of installments that were paid 4 or...
369	pctinstlsallpaidlate6d_3546844L	[train_static_0_0, train_static_0_1]	Percentage of installments that were paid 6 or...
370	periodicityofpmts_1102L	[train_credit_bureau_a_1_0, train_credit_burea...	Frequency of instalments for a closed contract.
371	periodicityofpmts_837L	[train_credit_bureau_a_1_0, train_credit_burea...	Frequency of instalments for an active contract.
372	periodicityofpmts_997L	[train_credit_bureau_b_1]	Frequency of instalments for active credit con...
373	periodicityofpmts_997M	[train_credit_bureau_b_1]	Frequency of instalments for active credit con...
374	personindex_1023L	[train_person_1]	Order of the person specified on the applicati...
375	persontype_1072L	[train_person_1]	Person type.
376	persontype_792L	[train_person_1]	Person type.
377	pmtamount_36A	[train_tax_registry_c_1]	Tax deductions amount for credit bureau payments.
378	pmtaverage_3A	[train_static_cb_0]	Average of tax deductions.
379	pmtaverage_4527227A	[train_static_cb_0]	Average of tax deductions.
380	pmtaverage_4955615A	[train_static_cb_0]	Average of tax deductions.
381	pmtcount_4527229L	[train_static_cb_0]	Number of tax deductions.
382	pmtcount_4955617L	[train_static_cb_0]	Number of tax deductions.
383	pmtcount_693L	[train_static_cb_0]	Number of tax deductions.
384	pmtdaysoverdue_1135P	[train_credit_bureau_b_1]	Number of days past due for existing contracts...
385	pmtmethod_731M	[train_credit_bureau_b_1]	Instalment payment method for existing contrac...
386	pmtnum_254L	[train_static_0_0, train_static_0_1]	Total number of loan payments made by the client.
387	pmtnum_8L	[train_applprev_1_0, train_applprev_1_1]	Number of payments made for the previous appli...
388	pmtnumpending_403L	[train_credit_bureau_b_1]	Number of pending payments for active contract.
389	pmts_date_1107D	[train_credit_bureau_b_2]	Payment date for an active contract according ...
390	pmts_dpd_1073P	[train_credit_bureau_a_2_4, train_credit_burea...	Days past due of the payment for the active co...
391	pmts_dpd_303P	[train_credit_bureau_a_2_4, train_credit_burea...	Days past due of the payment for terminated co...
392	pmts_dpdvalue_108P	[train_credit_bureau_b_2]	Value of past due payment for active contract ...
393	pmts_month_158T	[train_credit_bureau_a_2_4, train_credit_burea...	Month of payment for a closed contract (num_gr...
394	pmts_month_706T	[train_credit_bureau_a_2_4, train_credit_burea...	Month of payment for active contract (num_grou...
395	pmts_overdue_1140A	[train_credit_bureau_a_2_4, train_credit_burea...	Overdue payment for an active contract (num_gr...
396	pmts_overdue_1152A	[train_credit_bureau_a_2_4, train_credit_burea...	Overdue payment for a closed contract (num_gro...
397	pmts_pmtsoverdue_635A	[train_credit_bureau_b_2]	Active contract that has overdue payments (num...
398	pmts_year_1139T	[train_credit_bureau_a_2_4, train_credit_burea...	Year of payment for an active contract (num_gr...
399	pmts_year_507T	[train_credit_bureau_a_2_4, train_credit_burea...	Payment year for a closed credit contract (num...
400	pmtscount_423L	[train_static_cb_0]	Number of tax deduction payments.
401	pmtssum_45A	[train_static_cb_0]	Sum of tax deductions for the client.
402	posfpd10lastmonth_333P	[train_static_0_0, train_static_0_1]	Average FPD10 (Share of contracts with first i...
403	posfpd30lastmonth_3976960P	[train_static_0_0, train_static_0_1]	Average FPD30 (Share of contracts with first i...
404	posfstqpd30lastmonth_3976962P	[train_static_0_0, train_static_0_1]	Average FSTPD30 (share of contracts with first...
405	postype_4733339M	[train_applprev_1_0, train_applprev_1_1]	Type of point of sale.
406	previouscontdistrict_112M	[train_static_0_0, train_static_0_1]	Contact district of the client's previous appr...
407	price_1097A	[train_static_0_0, train_static_0_1]	Credit price.
408	processingdate_168D	[train_tax_registry_c_1]	Date when the tax deduction is processed.
409	profession_152M	[train_applprev_1_0, train_applprev_1_1]	Profession of the client during their previous...
410	prolongationcount_1120L	[train_credit_bureau_a_1_0, train_credit_burea...	Count of prolongations on terminated contract ...
411	prolongationcount_599L	[train_credit_bureau_a_1_0, train_credit_burea...	Count of active contract prolongations.
412	purposeofcred_426M	[train_credit_bureau_a_1_0, train_credit_burea...	Purpose of credit for active contract.
413	purposeofcred_722M	[train_credit_bureau_b_1]	Purpose of credit for active contracts.
414	purposeofcred_874M	[train_credit_bureau_a_1_0, train_credit_burea...	Purpose of credit on a closed contract.
415	recorddate_4527225D	[train_tax_registry_a_1]	Date of tax deduction record.
416	refreshdate_3813885D	[train_credit_bureau_a_1_0, train_credit_burea...	Date when the credit bureau's public sources h...
417	registaddr_district_1083M	[train_person_1]	District of person's registered address.
418	registaddr_zipcode_184M	[train_person_1]	Registered address's zip code of a person.
419	rejectreason_755M	[train_applprev_1_0, train_applprev_1_1]	Reason for previous application rejection.
420	rejectreasonclient_4145042M	[train_applprev_1_0, train_applprev_1_1]	Reason for rejection of the client's previous ...
421	relatedpersons_role_762T	[train_person_2]	Relationship type of a client's related person...
422	relationshiptoclient_415T	[train_person_1]	Relationship to the client.
423	relationshiptoclient_642T	[train_person_1]	Relationship to the client.
424	remitter_829L	[train_person_1]	Flag indicating whether the client is a remitter.
425	requesttype_4525192L	[train_static_cb_0]	Tax authority request type.
426	residualamount_1093A	[train_credit_bureau_b_1]	Residual amount of closed guarantee contract.
427	residualamount_127A	[train_credit_bureau_b_1]	Residual amount of active guarantee contract.
428	residualamount_3940956A	[train_credit_bureau_b_1]	Residual amount for the active contract.
429	residualamount_488A	[train_credit_bureau_a_1_0, train_credit_burea...	Residual amount of a closed contract.
430	residualamount_856A	[train_credit_bureau_a_1_0, train_credit_burea...	Residual amount for the active contract.
431	responsedate_1012D	[train_static_cb_0]	Tax authority's response date.
432	responsedate_4527233D	[train_static_cb_0]	Tax authority's response date.
433	responsedate_4917613D	[train_static_cb_0]	Tax authority's response date.
434	revolvingaccount_394A	[train_applprev_1_0, train_applprev_1_1]	Revolving account that was present in the appl...
435	riskassesment_302T	[train_static_cb_0]	Estimated probability that the client will def...
436	riskassesment_940T	[train_static_cb_0]	Estimate of client's creditworthiness.
437	role_1084L	[train_person_1]	Type of contact role.
438	role_993L	[train_person_1]	Person's role.
439	safeguarantyflag_411L	[train_person_1]	Flag indicating if client is using a flexible ...
440	secondquarter_766L	[train_static_cb_0]	Number of results in second quarter.
441	sellerplacecnt_915L	[train_static_0_0, train_static_0_1]	Number of sellerplaces where the same client's...
442	sellerplacescnt_216L	[train_static_0_0, train_static_0_1]	Number of sellerplaces where the same client's...
443	sex_738L	[train_person_1]	Gender of the client.
444	status_219L	[train_applprev_1_0, train_applprev_1_1]	Previous application status.
445	subjectrole_182M	[train_credit_bureau_a_1_0, train_credit_burea...	Subject role in active credit contract.
446	subjectrole_326M	[train_credit_bureau_b_1]	Subject role in active credit contract.
447	subjectrole_43M	[train_credit_bureau_b_1]	Subject role in closed credit contract.
448	subjectrole_93M	[train_credit_bureau_a_1_0, train_credit_burea...	Subject role in closed credit contract.
449	subjectroles_name_541M	[train_credit_bureau_a_2_4, train_credit_burea...	Name of subject role in closed credit contract...
450	subjectroles_name_838M	[train_credit_bureau_a_2_4, train_credit_burea...	Name of subject role in active credit contract...
451	sumoutstandtotal_3546847A	[train_static_0_0, train_static_0_1]	Sum of total outstanding amount.
452	sumoutstandtotalest_4493215A	[train_static_0_0, train_static_0_1]	Sum of total outstanding amount.
453	target	[train_base]	NaN
454	tenor_203L	[train_applprev_1_0, train_applprev_1_1]	Number of instalments in the previous applicat...
455	thirdquarter_1082L	[train_static_cb_0]	Number of results in third quarter.
456	totalamount_503A	[train_credit_bureau_b_1]	Total amount of active secured credit for a cl...
457	totalamount_6A	[train_credit_bureau_a_1_0, train_credit_burea...	Total amount of closed contracts.
458	totalamount_881A	[train_credit_bureau_b_1]	Total amount of secured credit from closed con...
459	totalamount_996A	[train_credit_bureau_a_1_0, train_credit_burea...	Total amount of active contracts in the credit...
460	totaldebt_9A	[train_static_0_0, train_static_0_1]	Total amount of debt.
461	totaldebtoverduevalue_178A	[train_credit_bureau_a_1_0, train_credit_burea...	Total amount of past due debt on active contra...
462	totaldebtoverduevalue_718A	[train_credit_bureau_a_1_0, train_credit_burea...	Total overdue debt amount for closed credit co...
463	totaloutstanddebtvalue_39A	[train_credit_bureau_a_1_0, train_credit_burea...	Total outstanding debt for active contracts in...
464	totaloutstanddebtvalue_668A	[train_credit_bureau_a_1_0, train_credit_burea...	Total outstanding debt for the closed contract...
465	totalsettled_863A	[train_static_0_0, train_static_0_1]	Sum of all payments made by the client.
466	totinstallast1m_4525188A	[train_static_0_0, train_static_0_1]	Total amount of monthly instalments paid in th...
467	twobodfilling_608L	[train_static_0_0, train_static_0_1]	Type of application process.
468	type_25L	[train_person_1]	Contact type of a person.
469	typesuite_864L	[train_static_0_0, train_static_0_1]	Persons accompanying the client during the loa...
470	validfrom_1069D	[train_static_0_0, train_static_0_1]	Date since the client has an active campaign.

lookuptable[lookuptable.File.apply(lambda x: 'train_credit_bureau_a_2_6' in x)]

	Variable	File	Description
49	case_id	[train_person_2, train_applprev_2, train_credi...	NaN
73	collater_typofvalofguarant_298M	[train_credit_bureau_a_2_4, train_credit_burea...	Collateral valuation type (active contract).
74	collater_typofvalofguarant_407M	[train_credit_bureau_a_2_4, train_credit_burea...	Collateral valuation type (closed contract).
75	collater_valueofguarantee_1124L	[train_credit_bureau_a_2_4, train_credit_burea...	Value of collateral for active contract.
76	collater_valueofguarantee_876L	[train_credit_bureau_a_2_4, train_credit_burea...	Value of collateral for closed contract.
77	collaterals_typeofguarante_359M	[train_credit_bureau_a_2_4, train_credit_burea...	Type of collateral that was used as a guarante...
78	collaterals_typeofguarante_669M	[train_credit_bureau_a_2_4, train_credit_burea...	Collateral type for the active contract.
294	num_group1	[train_person_2, train_applprev_2, train_credi...	NaN
295	num_group2	[train_person_2, train_applprev_2, train_credi...	NaN
390	pmts_dpd_1073P	[train_credit_bureau_a_2_4, train_credit_burea...	Days past due of the payment for the active co...
391	pmts_dpd_303P	[train_credit_bureau_a_2_4, train_credit_burea...	Days past due of the payment for terminated co...
393	pmts_month_158T	[train_credit_bureau_a_2_4, train_credit_burea...	Month of payment for a closed contract (num_gr...
394	pmts_month_706T	[train_credit_bureau_a_2_4, train_credit_burea...	Month of payment for active contract (num_grou...
395	pmts_overdue_1140A	[train_credit_bureau_a_2_4, train_credit_burea...	Overdue payment for an active contract (num_gr...
396	pmts_overdue_1152A	[train_credit_bureau_a_2_4, train_credit_burea...	Overdue payment for a closed contract (num_gro...
398	pmts_year_1139T	[train_credit_bureau_a_2_4, train_credit_burea...	Year of payment for an active contract (num_gr...
399	pmts_year_507T	[train_credit_bureau_a_2_4, train_credit_burea...	Payment year for a closed credit contract (num...
449	subjectroles_name_541M	[train_credit_bureau_a_2_4, train_credit_burea...	Name of subject role in closed credit contract...
450	subjectroles_name_838M	[train_credit_bureau_a_2_4, train_credit_burea...	Name of subject role in active credit contract...

# use jupyter notebook
from ipywidgets import interact, interactive, fixed, interact_manual
import ipywidgets as widgets

OUT = widgets.Output()

def f(feature=widgets.Text()):
    # OUT.clear_output()
    # with OUT:
    display(feature)
    # return(feature)
    if feature =="":
        return display(lookuptable);
    else:
        return display(lookuptable.query(f'Variable.str.contains("{feature}")'));
w=interactive(f)